How to merge two Excel documents so that second add to first as a new worksheet?

  • Thread starter Thread starter Melandre
  • Start date Start date
M

Melandre

Suppose I have 2 Excel documents with essentially the same
columns. Let's call them collection1.xls et
collection2.xls. Both have only 1 worksheet inside. I
want to take the worksheet from Collection2.xls and make
it Worksheet 2 of Collection1.xls.

I know it can be done with cut and paste but it seems to
me that when I try this, worksheet 2 does not seem to
duplicate all the styles and formatting of worksheet 1
(i.e. collection2 seems to lose some of its original
formatting during the cut and paste transfer to Worksheet
2 with the unwanted result that worksheet one looks
different than worksheet 2). Is there another way of
doing this? I know in WORD there use to be an APPEND
function to copy one document at the end of another
document. Is there something similar in EXCEL 2002?
TIA.
 
Melandre,

Right mouse click the worksheet. Move or Copy. Then you have to specify
where you want it moved or copied to.

That should do it.

Regards,
Kevin
 
Back
Top