Validation list
 

Is there a way of using a list from another worksheet without having
to bring the list into the current worksheet?

Hi!

Use a defined name.

Sheet2!A1:A10 named List

Data validation
Allow list
Source =List

Biff

-----Original Message-----
Is there a way of using a list from another worksheet
without having
to bring the list into the current worksheet?

.

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 he

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

smskater wrote:
Is there a way of using a list from another worksheet without having
to bring the list into the current worksheet?



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

On Wed, 22 Dec 2004 07:33:20 -0500, Debra Dalgleish
wrote:

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 he

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

smskater wrote:
Is there a way of using a list from another worksheet without having
to bring the list into the current worksheet?


Thank-you.