Data Validation List

[Patrick C. Simonds]

Is there any way to use a Data Validation List and have the source be on
another worksheet in the same workbook? I would like to put the source data
on another (hidden) worksheet so that users have NO access to it.

 

[Don Guillett]

Name it

=MYLIST

 

[Mike]

=INDIRECT("'Sheet2'!A1:A10")

 

[Dave Peterson]

Debra Dalgleish has lots of notes:
http://contextures.com/xlDataVal01.html#Name