Data Validation, source data on different sheet?

bsnapool

Active Member
Joined
Jul 10, 2006
Messages
452
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
 

Some videos you may like

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

Mrs. T

Board Regular
Joined
May 24, 2007
Messages
104
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?
 

Watch MrExcel Video

Forum statistics

Threads
1,108,986
Messages
5,526,065
Members
409,685
Latest member
Davetom

This Week's Hot Topics

Top