Pick lists

[engmgriff]

Hi

I have setup 1 pick list in a cell so that a user can pick from it.
Depending on what the user picks from this pick list I want anothe
pick list which the user can pick from. However this pick list i
related to the first pick list.

Therefore how do i get the second pick list available depending on th
first pick list.

Example say I have 5 options in pick list 1 within these 5 opiton i
another 5 pick lists which I want to make availabe depending on th
option chosen in pick list 1.

Thank

 

[Jason Morin]

If you're talking about lists created from Validation,
then MVP Debra Dalgleish has some instructions for
creating dependent lists:

http://www.contextures.com/xlDataVal02.html

HTH
Jason
Atlanta, GA

 

[jeff]

Hi,

An excellent tutorial for dependent lists is at
http://www.contextures.on.ca/xlDataVal02.html

jeff