Watch this 5 min video:

http://youtube.com/watch?v=t2OsWJijrOM


--
Biff
Microsoft Excel MVP


"WLMPilot" wrote in message
...
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