Hi,

I think you referring to Data Validations Lists which are dependent one from the other ...

The best solution is very well described by Debra ...

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

HTH
Carim