Hi Thanks for your reply
But when I select DataValidation, under allow I select List the only option
available is "Source". Please advise where do I have to type in the name the
gave to employee list


"Peo Sjoblom" wrote:

Select the data you want in the dropdown in the master sheet, give it a name
insertnamedefine, then select the cell in the 2nd sheet you want the
dropdown and do datavalidation, under allow select list and type in the
name you gave the employee list in the master sheet.

--


Regards,


Peo Sjoblom

"ub" wrote in message
...
Hi
I have a master sheet that has names of employees.
I have a 2nd sheet where my calculations are done based on employee
performance.
Is it possbile that on the column "Name of Employee" the information from
the master sheet can be made available as a drop down.
Or please advise, what other options I can have.