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

IBRA2018 · #21 04-09-2018, 10:33 PM

Quote:

Originally Posted by NoSparks

You're not considering the macro solution ?

No extra columns
No extra sheets
No formulas

Just click a button.

With do all respect I need to do some test on it so I can get used to it.

The work I'm doing will have lots of sheets and more cells.
SO I need to know how to edit the macro parts step by step

it looks great ... but I'm still a beginner and I need some times to deal with it and defiantly I will

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