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
|