Merge data into Excel

[skhayes]

I do monthly timesheets for about 40 employees. The timesheet is an Excel
document. I need to merge the employee name and ID# into the timesheet and
print to give to each employee. Can this be done in Excel?

 

[Kassie]

Yes you can! However, I would need more detailed info to really assist you!
Where are the Names and ID's kept? Is it in an Excel sheet or not? Can it
be imported into Excel, things like that you know.


Hope this helps

Kassie
(e-mail address removed)

 

[skhayes]

I have the information in a separate Excel file. Names are in one column and
ID# in another column. I want to be able to put their name and ID# at the
top of their timesheet. Thank you so much for your help!

 

[Kassie]

You would basically use a VLOOKUP formula to do this. I take it you have an
employee number on the timesheet, for each employee. Provided you then also
have this employee number in your name list, it is quite easy.

Say the emp nr is in A1, you want the name in B1 and the ID in C1
In B1 enter =IF(A1="","",VLOOKUP(A1,Employees.xls!Employees,2,0)) This
assumes that the names list has a range name of Employees, and that the file
name is Employees.xls

In C1, change the 2 to 3. By the way, if you do not know, the 2 and 3
refers to the column offset where the info is found in the list of employees.
So, if you have Nr, Surname, ID, then Surname is 2, and ID is 3