Restrict choices in one drop down list by response to another
 

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

Restrict choices in one drop down list by response to another
 

Check out this page:
http://www.contextures.com/xlDataVal02.html
--
Please remember to indicate when the post is answered so others can benefit
from it later.


"berniean" wrote:

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

Restrict choices in one drop down list by response to another
 

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


"berniean" wrote:

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

Restrict choices in one drop down list by response to another
 

Can't find it...can you be more specific as to the location on the site?
Thanks.

"Richard" wrote:

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


"berniean" wrote:

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

Restrict choices in one drop down list by response to another
 

Great site...lots of good advice...

"KC" wrote:

Check out this page:
http://www.contextures.com/xlDataVal02.html
--
Please remember to indicate when the post is answered so others can benefit
from it later.


"berniean" wrote:

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