How to create an Auto list with No Blank Cell -- HELP

IBRA2018 · #1 03-14-2018, 02:34 AM

Hi,,

I need your help guys..
I have created 2 Sheets one is to be filled manually and the second one is to be filled automatically as a result of what has been filled in Sheet-1

I have used some formula in Sheet-2 which works great to read from Sheet-1 , but it lists the Numbers or results as it appears in cells No. in Sheet-1 which leads to blank cells in between...

I have a attached 2 screen shot for the sheets

Sheet-1 (image 1) is the Master sheet
Sheet-2 (image 2) is the Result sheet where thinks is filled automatically (reads from Sheet-1)

in image 2 you can see the formula I used to read from Sheet-1

Thanks

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Create Drop Down list to change cell color	bksmith	Excel	2	08-21-2017 02:37 AM
Have a cell filled black when blank in dropdown list	Aussie_81	Excel	14	04-06-2017 04:50 AM
Formulato say if cell is blank do this, if not blank do this.	mbesspiata	Excel	1	01-17-2015 05:02 AM
Auto add a list cell if the last list cell is filled	tasuooooo	Excel	1	07-31-2012 08:40 PM
Auto-populate an MS Word table cell with text from a diff cell?	dreamrthts	Word Tables	0	03-20-2009 01:49 PM