|
|
|
|
#1
05-02-2018, 06:02 AM
|
|||
|
|||
I've currently attached the Excel workbook that I am trying to use for this. If you click on the first tab, named Card, you can see that I've organized some groups with names. Ideally, there would only be one cell which would contain all of these sheet names, and, depending on which one you select (from a dropdown), it would change the list values in a second dropdown which would be based off of the Person row in each of the sheets.
I'm also running into another issue where Ignore Blanks isn't working. I tried including a sample dropdown. 
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Looking to copy select cells in table using dropdown list to paste to new table in another worksheet | CaptainRetired | Excel Programming | 18 | 01-04-2018 07:22 PM |
 Use function to select another worksheet
|
eugeneradial | Excel | 2 | 04-27-2017 04:53 AM |
|
Select added value from dropdown menu, program output
|
Aleksm | Excel Programming | 1 | 01-28-2017 05:40 AM |
|
select a cluster of point from a range based on x and y values
|
sandcharles | Excel | 5 | 02-19-2015 06:15 AM |
|
Appending unique data from one worksheet to existing data on another worksheet
|
EdStockton | Excel | 1 | 08-06-2014 11:00 PM |
Windows 7 64bit 
Office 2010 64bit
Hybrid Mode