Drop down list from another drop down list

[Guest]

I would like to know how to setup another drop down list in the next cell
from whatever text is selected from the original drop down list beside it.
It seems easy but I can't get it to work in Excel. Thanks

 

[Dave Peterson]

You mean where the second cell's list depends on what was chosen in that first
cell?

I'd use some of the tips at Debra Dalgleish's site:
http://www.contextures.com/xlDataVal02.html