Data Validation, source data on different sheet?

[bsnapool]

Hi All

Just a quick one... Just wondering whether it is possible to have data validation 1 sheet and the source data on another?

If so, how??

Thanks

Andrew

 

[Andrew Poulsom]

Name the range you want to use eg List. Then set the Source of DV to =List.

 

[bsnapool]

Thankyou...

 

[Mrs. T]

I've tried this, but now the cell in which the validation is allows someone to overwrite in that cell without giving an error.

I've password protected my worksheet it still allows/accepts typed in data.

I only want to allow the lists. Is there a way to block this?