Merge from Excel to Excel

D

dalstar

I have the need to merge a data base of names (in exel) into a standardized
excel sheet to be used as payroll timesheets. I have been merging the excel
data base into a word document that was the timesheet, but Corporate has
changed the format into an excel timesheet. We are not allowed to change
the format.

Is it possible to merge an excel data base into another worksheet?

jm
 
E

Earl Kiosterud

jm,

If the layouts of the rows are the same, just paste the rows from the first
sheet under the standardized sheet, then sort as needed. If they're not the
same, get them that way first. You can quickly re-arrange columns by
selecting one, and hold Shift as you move (edge-drag) it right or left.
 
D

dalstar

Not sure I follow. I was hoping there was some command that would perform
similar to the "mail merge" in Word. The data base is a listing of
employees. The new timesheet is arranged in excel. At the top of the
timesheet is a cell noted as 'Name'. I want to merge the name into the
timesheet from the data base worksheet. Note: the data base and timesheet
are 2 different workbooks.
 
E

Earl Kiosterud

jm,

I see. You want a merge like that in Word. Excel doesn't do that. Use a
Word mail-merge, or an Access report (printout). Sometimes the word merge
is used in the sense of combine. If you must do it in Excel, it can be done
either via a macro, or for ad-hoc single records (you want only a particular
one), with formulas.
 
Top