Pick Lists

[tkm]

I want to input data into a cell and then use that specific data to determine which pick list to use for another cell. Any ideas?

 

[Gord Dibben]

Sounds like dependent Data Validation Lists would do the trick.

Se Debra Daleish's site for info and instructions.

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

Gord Dibben Excel MVP