hi
validation applies to the sheet meaning like the message said, you can't
reference other sheet with validation. i have never tried but i doubt that a
macro will help. you source need to be on the sheet the validation is on.

Regards
FSt1

"WLMPilot" wrote:

I want to create a list via validation that will reference a the employee
list on another worksheet. The list appears in column A of sheet
"Employees". I have also named the list "Employees".

I have tried:

='Employees'!Employees
='Employees'!A:A
=Employees!Employees

I get a message that you cannot reference a worksheet in validation.

Is there a way to do this without using a macro?

Thanks,
Les