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

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

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