pull downs and variables

[darqphire]

I wish to have a pull down menu containing 15 choices each of which would cause a given groups of cells to display a list of pre-arranged text.

Ex: choose "A" from pulldown in (C2); and (D16) through (D35) would display a custom list.... but if you choose "B" from the pulldown, a seperate list would appear instead...

Any help in this would be greatly appreciated.

[Roger Govier]

Hi

Take a look at Debra Dalgleish's site for help on this topic
http://www.contextures.com/xlDataVal02.html

--
Regards

Roger Govier


"darqphire" <[email protected]>
wrote in message
news:[email protected]...
>
> I wish to have a pull down menu containing 15 choices each of which
> would cause a given groups of cells to display a list of pre-arranged
> text.
>
> Ex: choose "A" from pulldown in (C2); and (D16) through (D35) would
> display a custom list.... but if you choose "B" from the pulldown, a
> seperate list would appear instead...
>
> Any help in this would be greatly appreciated.
>
>
> --
> darqphire
> ------------------------------------------------------------------------
> darqphire's Profile:
> http://www.excelforum.com/member.php...o&userid=36660
> View this thread:
> http://www.excelforum.com/showthread...hreadid=564067
>

[Bob Phillips]

The way to do this is as follows

The lists to use in D16:D35 should be entered as list in separate ranges,
and all named using a naming convention, such as List1, List2, List3, or say
ListEurope,ListAsia, ListAFrica, etc., where the 1,2,3 or Europe, Asia,
Africa are the values that will be selectable in the C2 list.

Then in DV in D16:D35, set the DV to an allow type of 'List', and use a
formula of

=INDIRECT("List"&C2)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"darqphire" <[email protected]> wrote
in message news:[email protected]...
>
> I wish to have a pull down menu containing 15 choices each of which
> would cause a given groups of cells to display a list of pre-arranged
> text.
>
> Ex: choose "A" from pulldown in (C2); and (D16) through (D35) would
> display a custom list.... but if you choose "B" from the pulldown, a
> seperate list would appear instead...
>
> Any help in this would be greatly appreciated.
>
>
> --
> darqphire
> ------------------------------------------------------------------------
> darqphire's Profile:
http://www.excelforum.com/member.php...o&userid=36660
> View this thread: http://www.excelforum.com/showthread...hreadid=564067
>

[darqphire]

Hi again,
I know it's been ages since you posted that reply to my question, but I wanted you to know that I really appreciate it. The Indirect Function connected to the Named Range idea worked great. I have another problem of a different sort now, but I think I will post a new thread with a new topic name. (This thread can be deleted by a moderator or whatever. Thanks.)