Creating drop downs in a cell contingent on another drop down




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?



Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question