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.