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

no way. the sysadmin says:

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

Anything else?

ANdras

"ANdras" wrote:

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

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.

Hello Brablo,

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


"Brablo" wrote:

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