Validation list

[smskater]

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

 

[Biff]

Hi!

Use a defined name.

Sheet2!A1:A10 named List

Data validation
Allow list
Source =List

Biff

 

[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

 

[smskater]

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

Thank-you.