Data Validation based around previous Data validated Cell

[DebugGalpin]

Hi there,

I have hit the wall on this one and am looking for some help.

I have a series of dynamic ranges named in the "Name Manager" function using an offset formula.

Data Validation on Cell 1 provides a Business Name and works using the dynamic named range.

Cell 2 needs to then provide a drop down based around the result of Cell 1.

E.g. Cell 1 you choose BP, I wish Cell 2 to then pick up my dynamic name range "ContactsBP"

Any help would be much appreciated. I do have a table set up that gives the Name range for Cell2 basis the result of Cell1, which could potentially be incorporated

Any help greatly appreciated

 

[VoG]

This should help you http://www.contextures.com/xlDataVal02.html

 

[DebugGalpin]

that doesn't seem to work on a dynamic range not sure why, had tried that site before, it works on a range if I name it by highlighting the cells and calling them "BP" but then the range is not dynamic which it will need to be
Cheers

 

[Andrew Poulsom]

Did you see this?

http://www.contextures.com/xldataval02.html#Dynamic