Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Getting names data information from another sheet
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Getting names data information from another sheet
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Getting names data information from another sheet
If you are just trying to pull an employee across, you can do one of the
following: NOTE: Assuming Master sheet is titled Master, and employee names are in column A. On the master sheet, name column A:A as something unique: i.e.: EmpName On your second sheet, in the cell you wish to pull the employee name from, go to Data--Validation, choose List, and in the Source type: =EmpName The second suggestion is very similar, in that you don't have to name the EmpName column, but in the Source field for Data Validation type the following: =Indirect("MASTER!A:A") After either one of these, you can use VLOOKUPS to pull the appropriate data column from the Master tab -- John C "ub" wrote: 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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Getting names data information from another sheet
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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Getting names data information from another sheet
Yes, in the source box you should type in the name of the list like this
=MyName I should have remembered to add that you need an equal sign, sorry about that -- Regards, Peo Sjoblom "ub" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using names, and related information, in a Pivot Table? | Excel Worksheet Functions | |||
Data Base, copy information one sheet to another automatically | Excel Discussion (Misc queries) | |||
Displaying information (contained in defined names) on a summary sheet, in different row numbers? | Excel Discussion (Misc queries) | |||
How do I sort entire spread sheet. Names w/data | Excel Worksheet Functions | |||
Import data file but exlude information I already have in sheet? | Excel Discussion (Misc queries) |