Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merging 2 unequal workbooks
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merging 2 unequal workbooks
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merging 3 workbooks when they are not exactly the same | Excel Worksheet Functions | |||
Merging workbooks | Excel Discussion (Misc queries) | |||
Merging seperate workbooks into one workbook | Excel Discussion (Misc queries) | |||
Should Merging workbooks pick up new data or only edited data? | Excel Worksheet Functions | |||
Merging data from several workbooks | Excel Worksheet Functions |