Creating a pulldown menu...

[Brablo]

Hello,

How do I create a pulldown menu on sheet 1, in column A, which has a
list of all 50 states in it? The states are listed in sheet 2 from
cell A1:A51.

I believe that this involves the vlookup command.

Thanks in advance.

 

[Bob Phillips]

See http://www.contextures.com/xlDataVal01.html

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Guest]

Hello,

give a Name to the Sheet2!A1:A51, e.g. Statelist
Then on SHeet1 the required cell:
Data/Validation/lists and for the source: =Statelist

Voilá

Best regards,
ANdras

 

[Brablo]

I'm not sure if I can implement this.

 

[Bob Phillips]

which part are you unsure of?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Guest]

Hi Brablo,

in steps:
1) select the range of the states (Sheet2 A1:A51)
2) either Insert / Name I> / Set/Give Names > then you can gve 1 name to the
selected range (e.g. TheListOfStates)
3) then on sheet1 go to the cell, where you want the pulldown menu and
4) Data / Validation / select List and for the source just type:
=TheListOfStates and confirm with OK.
5) copy the validation to all cells you want the same pulldown list.

i am sure you can do it

Best regards,
ANdras
(Hungary)

 

[Brablo]

Hello Andras,

Thank you for your encouragement. I appreciate it. Is there any way
that you can send me the attachment to:

(e-mail address removed) ?

Please have the combo box in sheet 1, but the data in sheet 2.

I totally appreciate this.

 

[Guest]

Hi Brablo,

i have sent it.
and still: you can do it

Regards,
ANdras

 

[Guest]

no way. the sysadmin says:

"delivery error: dd Sorry your message to (e-mail address removed) cannot
be delivered. This account has been disabled or discontinued [#102]. -
mta307.mail.mud.yahoo.com>"

Anything else?

ANdras

 

[Brablo]

Hello my friend!

Thanks so much for your efforts. I have finally found out how to do
it! Before, I had never learned the text box (the box to the left of
the function box) where one creates the list. That concept was alien
to me.

I appreciate everything.

 

[Guest]

Hello Brablo,

i am glad you found the right solution!
Have fun
ANdras