P
PapaBear
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.
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.