multiple drop-downs

[shav]

Hi all,
is it possible for a cell to have different drop-down list
depending on the value in another cell. Cheers
Sha

 

[Debra Dalgleish]

You can use dependent data validation lists. There are instructions here:
http://www.contextures.com/xlDataVal02.html

 

[shav]

Perfect! Thanks alo