See Debra Dalgleish's coverage of Dependent Lists:
http://www.contextures.com/xlDataVal02.html

Post back if you have more questions.

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
"menugal" wrote in message
...
I am trying to make a simple spreadsheet with dropdown menus where if you
choose 1 item from the first drop down menu the subsequent dropdown menus
will only display the items that pertain to the item in the first mene.