pull downs and variables

[darqphire]

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

Ex: choose "A" from pulldown in (C2); and (D16) through (D35) woul
display a custom list.... but if you choose "B" from the pulldown,
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]...

 

[Bob Phillips]

The way to do this is as follows

The lists to use in D1635 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 D1635, 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)