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

		Microsoft Office Forums > Microsoft Excel > Excel Programming
How to create an Auto list with No Blank Cell -- HELP

FAQ

Thread Tools

Display Modes

#22

04-10-2018, 02:23 AM

IBRA2018

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

Windows 8

Office 2016

Novice

Join Date: Mar 2018

Posts: 17

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"

Attached Files

Project_Status-2_with_macro.xlsm (185.4 KB, 9 views)

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 05:21 AM.