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

NoSparks · #1 04-05-2018, 09:01 AM

You're not considering the macro solution ?

No extra columns
No extra sheets
No formulas

Just click a button.

IBRA2018 · #2 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

IBRA2018 · #3 04-10-2018, 02:23 AM

Quote:

Originally Posted by NoSparks

You're not considering the macro solution ?

No extra columns
No extra sheets
No formulas

Just click a button.

How to edit the macro to display 2 sheets "2017" & "2018" results into the Report sheet
side by side results.

because in the future I will have more sheets and more columns added

plz find the attached file.

Now it displays "2017"

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