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

Giganews Newsgroups
Subject: How to merge two Excel documents so that second add to first as a new worksheet?
Posted by:  Melandre (anonymo…@discussions.microsoft.com)
Date: Mon, 27 Oct 2003

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.

Replies