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.