View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Otto Moehrbach Otto Moehrbach is offline
external usenet poster
 
Posts: 1,090
Default 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