Is it possible to merge data from an excel spreadsheet such as employee names and merge them in to another spread sheet such as an employee time sheet that is in excel. I would like it to work like mail merge with Word only from Excel to excel.

Nothing like mail merge other than writing a macro. Do the two files have the same layout? You can't copy/paste

HTH
texasalynn

One way that this may be possible is to use the following formula,

='Location of document \ [documentname.xls]Sheet1'!A1

i.e.

='C:\My Documents\[Book1.xls]Sheet1'!R3C3

This will only update everytime you refresh or when you have both documents open at the same time.

Christy

LOOKUP tables might bring the data in for you. Probably a vertical lookup VLOOKUP where your employee name spreadsheet is your lookup range and has to be displayed alpabetically. I am not a lookup expert by anymeans but have used them sucessfully for many simple "merges" in excel. Check the help files in excel on them and if you want to explore it more, email me. I'll help the best that I can.
Melinda