If Then with Validation
 

I have setup a cell so that it validates against a list on a different
worksheet in the workbook. But based upon which item is selected from the
list I want the next cell to be a different validation list -- e.g. If I
select B from the validation list I want the next cell to give me a list of
options 8 - 15, but if I select C from the first validation list I want the
next cell to give me a list of options 16 - 25. I can't find any function
that will do this? Is there anyway to accomplish this? It is almost like a
If a specific Item is selected from the first validation list, Then that will
determine the Validation list for the next cell.

If Then with Validation
 

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


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"PapaBear" wrote in message
...
I have setup a cell so that it validates against a list on a different
worksheet in the workbook. But based upon which item is selected from the
list I want the next cell to be a different validation list -- e.g. If I
select B from the validation list I want the next cell to give me a list
of
options 8 - 15, but if I select C from the first validation list I want
the
next cell to give me a list of options 16 - 25. I can't find any function
that will do this? Is there anyway to accomplish this? It is almost like
a
If a specific Item is selected from the first validation list, Then that
will
determine the Validation list for the next cell.

If Then with Validation
 

Dependent DV list instructions from Debra's site.

http://www.contextures.on.ca/xlDataVal02.html


Gord Dibben MS Excel MVP

On Mon, 18 Feb 2008 15:52:01 -0800, PapaBear
wrote:

I have setup a cell so that it validates against a list on a different
worksheet in the workbook. But based upon which item is selected from the
list I want the next cell to be a different validation list -- e.g. If I
select B from the validation list I want the next cell to give me a list of
options 8 - 15, but if I select C from the first validation list I want the
next cell to give me a list of options 16 - 25. I can't find any function
that will do this? Is there anyway to accomplish this? It is almost like a
If a specific Item is selected from the first validation list, Then that will
determine the Validation list for the next cell.