Creating drop downs in a cell contingent on another drop down

[Keeprogoal]

Hello!

I want to create a drop down menu in a cell (I am using Data/Validation to
create a drop down menu based on a list I am putting in some hidden cells),
but I want the menu to be different in the second drop down based on the
selection of the first... for example if someone picks "B" from the first
list of "A", "B", "C", then the second drop down section will show "B.1",
"B.2" and "B.3" as opposed to the second drop down showing all available
options like "A.1" thru "C.3".

Can this be done?

Thanks!

 

[Gary''s Student]

See:

http://www.contextures.com/xlDataVal02.html