Merge Excel Documents

[jllawrence]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)

Hi folks,

Is there any way to merge two separate excel documents into one another? I need a column of information from one original document and the rest of my information from columns in another document. Is it possible to do this?

 

[Bob Greenblatt]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)

Hi folks,

Is there any way to merge two separate excel documents into one another? I
need a column of information from one original document and the rest of my
information from columns in another document. Is it possible to do this?

If the column layouts are the same, just copy the columns from one sheet to
the bottom of the other. Then sort.

 

[jllawrence]

Hey there,

The columns are not the same...that's the problem I am running into

Jen

 

[JE McGimpsey]

The columns are not the same...that's the problem I am running into

Perhaps if you described how they differ, and what your end result
should look like, it would be easier to help.

You can copy a worksheet from one workbook to the other (Edit/Move or
Copy Worksheet).

Or you could reference cells in one workbook from the other.

Or you could use formulas (INDEX, VLOOKUP, etc) to match data in one
book with data in the other and extract it.

Or perhaps something else entirely.