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

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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