Data Validation

[Galsaba]

How can I create a drop down list, while the list of item to be choose will be
on a different worksheet?

GalSaba

[Debra Dalgleish]

If you name the list on the other sheet, you can refer to it by name in
the data validation dialog box. There are instructions here:

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


Galsaba wrote:
> How can I create a drop down list, while the list of item to be choose will be
> on a different worksheet?
>
> GalSaba


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

[Peo Sjoblom]

Use a named range and then refer to that name, i.e.

list is in A1:A20 sheet2

select the range and name it MyList, now in the other sheet select the
cell, do data>validation>allow>list and use

=MyList



--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)



"Galsaba" <[email protected]> wrote in message
news:[email protected]...
> How can I create a drop down list, while the list of item to be choose
> will be
> on a different worksheet?
>
> GalSaba

[Dave Peterson]

Define a Range Name.

Debra Dalgleish has some nice instructions at:
http://www.contextures.com/xlDataVal01.html#Name

And if that list can grow, you could define a name that refers to a dynamic
range.
http://www.contextures.com/xlNames01.html#Dynamic


Galsaba wrote:
>
> How can I create a drop down list, while the list of item to be choose will be
> on a different worksheet?
>
> GalSaba

--

Dave Peterson