I think you're referring to Dependent Lists. See Debra Dalgleish's website
for instructions on how to set them up:

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

Does that help?
***********
Regards,
Ron

XL2002, WinXP-Pro


"frustrated" wrote:

I have a drop down list. I want the selection made from this list to determin
what choices are avaialbe in the next drop down list. How would i do this?