How can i put data Validation on a different worksheet

J

Joe Black

Hello
Is there any way to put the data i use to validate a dropdown 'list', on o
different worksheet.
thank you
 
O

Otto Moehrbach

Yes. Just name the list, say TheList. Then when you setup the Data
Validation cell, select List, and in Source, type "=TheList" without the
quotes. HTH Otto
 
B

Biff

Yes, just give the source data a defined name and use that defined name as
the source:

Sheet2 A1:A10 = defined name List

Drop down list in Sheet1 A1
Source: =List

Biff
 
J

Joe Black

Thanks guys.. worked a treat

Biff said:
Yes, just give the source data a defined name and use that defined name as
the source:

Sheet2 A1:A10 = defined name List

Drop down list in Sheet1 A1
Source: =List

Biff
Click to expand...
 
Top