pull downs and variables
 

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

pull downs and variables
 

Hi

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

--
Regards

Roger Govier


"darqphire"
wrote in message
...

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

pull downs and variables
 

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" wrote
in message ...

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