creating a pulldown based on the value of another pulldown menu
 

I want to crate a pull down menu based on the value from another pull down
menu. E.g.
If I select 1 from the first pull down menu then the values X,Y,Z
(corresponding value associated with 1) would be in another pull down in a
different location.

1st Pull down Values 2nd Pull down Values

1 X,Y,Z
2 A,B,C
3 E,F,G
4 O,P,Q

creating a pulldown based on the value of another pulldown menu
 

Debra Dalgleish has the answer

http://www.contextures.on.ca/xlDataVal02.html


Gord Dibben MS Excel MVP

On Thu, 11 Sep 2008 07:58:02 -0700, kami
wrote:

I want to crate a pull down menu based on the value from another pull down
menu. E.g.
If I select 1 from the first pull down menu then the values X,Y,Z
(corresponding value associated with 1) would be in another pull down in a
different location.

1st Pull down Values 2nd Pull down Values

1 X,Y,Z
2 A,B,C
3 E,F,G
4 O,P,Q