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.

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.