Dropdown menu auto recognition?
 

I have a drop down menu of two options (yes or no) in cell A1. Cell B1 has
another drop down menu of 50 options. Is it possible that when "yes" is
selected in A1 only certain options appear in the B1's drop down menu, and
that when "no" is selected in A1, certain other options appear?


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200508/1

There are instructions here for creating dependent data validation lists:

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

Patty via OfficeKB.com wrote:
I have a drop down menu of two options (yes or no) in cell A1. Cell B1 has
another drop down menu of 50 options. Is it possible that when "yes" is
selected in A1 only certain options appear in the B1's drop down menu, and
that when "no" is selected in A1, certain other options appear?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

One play ..

Assume the first 25 items of the 50 options in B1 are in a list named:
List1,
with the second 25 items in a list named as: List2

Then in the DV creation for B1, the settings could be:
Under Allow: List
In the "Source:" box, we could try:
=IF(A1="yes",List1,IF(A1="no",List2,""))

If selection in A1 is: yes, B1's DV shows List1's items
If selection in A1 is: no, B1's DV shows List2's items

You may also wish to browse these 2 excellent references for more info:

Debra's "Excel -- Data Validation -- Create Dependent Lists" at:
http://www.contextures.com/xlDataVal02.html

Bob Phillips' "Dynamic Dependent Dropdowns" at:
http://www.xldynamic.com/source/xld.Dropdowns.html

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Patty via OfficeKB.com" wrote in message
...
I have a drop down menu of two options (yes or no) in cell A1. Cell B1 has
another drop down menu of 50 options. Is it possible that when "yes" is
selected in A1 only certain options appear in the B1's drop down menu, and
that when "no" is selected in A1, certain other options appear?


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200508/1

Thank you!

Is the only possible way to do this is with named ranges? Because in the
contextures.com example, supposed I am using the produce list for a third
drop down menu. How can I have the same name for 2 different named ranges?


Debra Dalgleish wrote:
There are instructions here for creating dependent data validation lists:

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

I have a drop down menu of two options (yes or no) in cell A1. Cell B1 has
another drop down menu of 50 options. Is it possible that when "yes" is
selected in A1 only certain options appear in the B1's drop down menu, and
that when "no" is selected in A1, certain other options appear?



--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200508/1

You could name the second range something slightly different, e.g. if
the first range is named "Fruit", name the second one "FruitB"

Then, in the data validation source for the second dropdown, use the
formula:
=INDIRECT(B3&"B")

Patty via OfficeKB.com wrote:
Thank you!

Is the only possible way to do this is with named ranges? Because in the
contextures.com example, supposed I am using the produce list for a third
drop down menu. How can I have the same name for 2 different named ranges?


Debra Dalgleish wrote:

There are instructions here for creating dependent data validation lists:

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


I have a drop down menu of two options (yes or no) in cell A1. Cell B1 has
another drop down menu of 50 options. Is it possible that when "yes" is
selected in A1 only certain options appear in the B1's drop down menu, and
that when "no" is selected in A1, certain other options appear?





--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html