See the discussion in this thread:
http://www.microsoft.com/office/comm...4-868f0a34297f
and see if that doesn't cover your situation. I think it does, and if so,
there are example worksheets there that you can probably use or adapt for
your needs.


"Chuck" wrote:

Hi all,

I have a question about how to merge 2 unequal workbooks. One workbook
is the subset of the other, and the smaller workbook has another column
that I wish to export to the larger workbook.

File 1:

A
B
C
D
E

File 2:

A 2
C 3

I want to have something like

A 2
B
C 3
D
E

Anyone knows how to do it? Your comments and help are greatly
appreciated