filter dropdown menu so 2nd drop menu is customized

[menugal]

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.

 

[Ron Coderre]

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)