#1
|
|||
|
|||
First of all check to cells and after drop down list
I would like a drop down list after first checking the customer in the cell B2 , then checking the fruit in the cell Β5 and then in cell Β9 to have a list of descriptions corresponding to each client.
Thank you |
#2
|
||||
|
||||
try attached.
|
#3
|
|||
|
|||
Added is a solution without any code. (All columns/sheets with 'Hidden' in name may be hidden).
The same can be done without defining Tables - using dynamic Named Ranges instead. But formulas will be more cumbersome. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to import list from Excel into drop-down list into word | ahw | Word VBA | 43 | 02-28-2020 08:11 PM |
Drop down box list based on response to another drop down box | Phideaux | Excel | 16 | 04-13-2018 03:07 AM |
Having a Drop-down list in Word referring to an Excel list | celias | Word VBA | 3 | 07-11-2016 11:40 PM |
Drop down list to overlay column of cells with different formulae | TomJ | Excel | 0 | 12-19-2015 08:55 AM |
How to "hard link" two adjacent cells to a data validation drop down list? | Geza59 | Excel | 10 | 10-19-2012 11:56 AM |