How can i put data Validation on a different worksheet
 

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

How can i put data Validation on a different worksheet
 

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
"Joe Black" wrote in message
...
Hello
Is there any way to put the data i use to validate a dropdown 'list', on o
different worksheet.
thank you

How can i put data Validation on a different worksheet
 

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

"Joe Black" wrote in message
...
Hello
Is there any way to put the data i use to validate a dropdown 'list', on o
different worksheet.
thank you

How can i put data Validation on a different worksheet
 

Thanks guys.. worked a treat

"Biff" wrote:

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

"Joe Black" wrote in message
...
Hello
Is there any way to put the data i use to validate a dropdown 'list', on o
different worksheet.
thank you

How can i put data Validation on a different worksheet
 

You're welcome!

Biff

"Joe Black" wrote in message
...
Thanks guys.. worked a treat

"Biff" wrote:

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

"Joe Black" wrote in message
...
Hello
Is there any way to put the data i use to validate a dropdown 'list',
on o
different worksheet.
thank you

How can i put data Validation on a different worksheet
 

Joe
Thanks for the feedback. Otto
"Joe Black" wrote in message
...
Thanks guys.. worked a treat

"Biff" wrote:

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

"Joe Black" wrote in message
...
Hello
Is there any way to put the data i use to validate a dropdown 'list',
on o
different worksheet.
thank you

How can i put data Validation on a different worksheet
 

Biff,
Can I create one list in Sheet A from different sheets B/C/D

"Biff" wrote:

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

"Joe Black" wrote in message
...
Hello
Is there any way to put the data i use to validate a dropdown 'list', on o
different worksheet.
thank you