Multi-Level Data Validation Problem

I was completely through editing my document, but had to change two tab names (and their names associated throughout the rest of the workbook). The workbook is attached for your consideration.

“CCLT_17_14_1” was previously labeled as “Klause_19_9”

And “Morgan_13_5” was previously labeled as “Hendrick_27_7”

Everything is still working correctly except my second data validation [Second Selection – Select Date:] on the REPORT tab.

What did I do and how do I fix it? All help is appreciated!

The wrong attachment was uploaded, please see reply for correct attachment

Whats not working?
when I change the first DV drop down, the List for second one changes, Is that not what is supposed to happen?

clearer now with the new book
the DV for second Validation list is still referencing your old names, change that to the new names and it should work fine

You'll have to create those named ranges for that to work, see attachment

as a Temporary work around,this may help while you work the bugs out:
=IF(B13="Morgan_13_5",Hendrick_27_7,Klaus_19_9)

but it will probably cause you more grief in the end

In the attachment, I created the named ranges, THEN applied your formula (=IF(B13="Morgan_13_5",Morgan_13_5,CCLT_17_14_1))
You probably still have to work out some references in the rest of the sheet, but it should be easier with all the names being consistent to your actual data names

The formula will change as you add more tabs, a few could be added by nesting more if's but if you expect a large number of tabs, a different approach would be needed, a quick google search returns several sites showing methods of creating dependent data validation lists

Hope this helps

Cross post here

http://www.ozgrid.com/forum/showthread.php?t=175354

Thanks Fotis, I'll unsubscribe this thread now, especially as it seems you already solved this

................