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

IBRA2018 · #1 03-26-2018, 11:15 PM

Quote:

Originally Posted by NoSparks

I don't know the purpose or ultimate goal for this but my first inclination would be to use a macro rather than formulas.
With the exception of A2 being blank, it appears you're wanting the columns of your second sheet to be what filtering for those columns in the first sheet would be.

Thanks, but I'm not that good in xl formulas/programming

I'm trying my best to apply things form the internet ... That's why I need your help and guidelines

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