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

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.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"dalstar" wrote in message
...
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

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.


"Earl Kiosterud" wrote in message
...
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.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"dalstar" wrote in message
...
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

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.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"dalstar" wrote in message
...
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.


"Earl Kiosterud" wrote in message
...
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.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"dalstar" wrote in message
...
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