Restrict choices in one drop down list by response to another

B

berniean

Greetings: I have a spreadsheet form with four cells that have data
validation in the form of drop down lists. The lists reside on another tab
within the same workbook. I would like to be able to restrict the 2nd list to
specific choices based on the response to the 1st list. In other words, if
someone chooses Product A in the 1st cell, they would only see choices in the
2nd cell that are appropriate to Product A. Same for Product B, etc. Then, of
course, I'd like to further restrict the 3rd list by the response to the 2nd,
and the 4th by the 3rd. Can this be done without Visual Basic (which I know
nothing about)? If so, how would I go about it?
Thank you, bernie
 
R

Richard

I have just seen how to do this in excel how to on the microsoft site, check
it out. good luck.
 

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

Similar Threads

Drop Down Lists 2
Filtered drop down list 2
Linking drop down lists to another list 4
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Drop down list ???? 1
drop down list 3
Restrict Choice in Shared WB (drop down alternative)? 0
Data validation won't restrict user input - please help 1

Top