| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop down menu display based on the value of different cell
Say I have the cell A1 - it has a drop down menu and Cell A2 also has a drop
down menu. I want the drop down menu of A2 to change based on the value in A1 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Drop down menu display based on the value of different cell
use indirect function for A2
On May 30, 3:55*pm, Alex3020 wrote: Say I have the cell A1 - it has a drop down menu and Cell A2 also has a drop down menu. I want the drop down menu of A2 to change based on the value in A1 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Drop down menu display based on the value of different cell
There are instructions here for creating dependent data validation lists:
http://www.contextures.com/xlDataVal02.html Alex3020 wrote: Say I have the cell A1 - it has a drop down menu and Cell A2 also has a drop down menu. I want the drop down menu of A2 to change based on the value in A1 -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Source Range Data changing based on drop-down menu | Charts and Charting in Excel | |||
| Drop Down Menu to display a field of data | Excel Worksheet Functions | |||
| The drop down menu of my validation list needs to display more. | Excel Discussion (Misc queries) | |||
| display a drop-down list based on the content of another cell | Excel Discussion (Misc queries) | |||
| need to populate several cells based on drop down menu selection | Excel Discussion (Misc queries) | |||
Hybrid Mode
