Dynamic Ranges

[TheRevelator]

I am trying to implement a solution whereby the location of a range is determined by the value of a given cell. As an example, I have 3 lists in A1:A4, B1:B5 & C1:C3. A1, B1 & C1 are list headings. There is a drop down list in cell D1 with these list headings and a further drop down list in cell D2.

The drop down list is D2 needs to bring back the values from either of the 3 lists depending on what value has been selected in D1.

For arguments sake, we can call the Ranges; RangeA (A1:A4), RangeB (B1:B4) and RangeC (C1:C4)

I would be grateful for any advice you could give.

Cheers

[NBVC]

I think you're talking about dependent lists...

see here for instructions on how to implement:

http://www.contextures.com/xlDataVal02.html

[TheRevelator]

That's the one - cheers for your help.