Hi Bob,

Hope you and your family had a lovely New Year.

I have been playing with this great dependent data validation code set up that you have shown me.

I have attached a workbook, with a suitably created DV list of Funds and their relevant members (all ficticious foir this example), oin the "Admin" worksheet.

In the worksheet called "DV", I have coloured in a few cells where I would like to enter the validation. The colour of the cells corresponds to the relevant level of dependent data validation i would like to have in that cell based on the colours from the "Admin" worksheet.

To be more explicit, for this example:

Dep1, Dep4 depend on A1
Dep2 depends on Dep1
Dep5 depends on Dep4
Dep6, Dep7 depend on Dep5
Dep8 depends on Dep2
Dep9 depends on Dep4
Dep10 depends on Dep9

I have labelled the relevant named ranges as Dep1-Dep10 (no particular reeason, just that I would like to work with named ranges in my application).

Q: Could you please show how to modify your event code to make the above dependencies occur please.

Q2: Also you mentioned above that the event code requires you to manually set up the arrays that identify the relevant locations of the dependent cells - id it possible for the event code to work these out, as with named ranges these may move around a bit initially?

As you know I sincerely value your input and would be grateful if you could help out with this.