drop down list help

[Tree]

I need to make a drop down list that changes options to choose based on what
is chosen in other drop down lists.

 

[Dave Peterson]

Maybe you could use Data|Validation and use dependent lists.

See Debra Dalgleish's site for some instructions:
http://contextures.com/xlDataVal02.html