Creating a pulldown menu...

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.

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Brablo" <gestureofrespect@yahoo.com> wrote in message
news:1145472846.745120.66690@i40g2000cwc.googlegroups.com...
> 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.
>

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" wrote:

> 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.
>
>

I'm not sure if I can implement this.

which part are you unsure of?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Brablo" <gestureofrespect@yahoo.com> wrote in message
news:1145483846.840870.175190@e56g2000cwe.googlegroups.com...
> I'm not sure if I can implement this.
>

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" wrote:

> I'm not sure if I can implement this.
>
>

Hello Andras,

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

gestureofrespect@yahoo.com ?

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

I totally appreciate this.

Hi Brablo,

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

Regards,
ANdras

"Brablo" wrote:

> Hello Andras,
>
> Thank you for your encouragement. I appreciate it. Is there any way
> that you can send me the attachment to:
>
> gestureofrespect@yahoo.com ?
>
> Please have the combo box in sheet 1, but the data in sheet 2.
>
> I totally appreciate this.
>
>