Before you can merge workbooks you should get comparison report for them. Step by step instruction
can be found in How to compare 2 workbooks topic.
Merge changed cells:
You should select changed cells in worksheet view. You can merge them one by one or you can
select range which contains several changed cells, and some equal cells (as in this example).
Equal cells will not be changed and you merge all selected changes at once.
If you have Synchronous Selection option selected (read this topic to find
more information about this command) in other worksheet view xlCompare selects corresponding range and you see,
that cells corresponding to changed cells will be updated.
If Synchronous Selection option is OFF, you should select first cell of the destination range yourself.
Then use Use this range command from the right click menu on the source range.
This command replaces contents of the destination range with data from source range.
In brief, to merge changed cells you should select range which contains these cells and use
Use this range command from the right click menu.
Merge added and deleted rows:
Rows are merged similarly to cells - you should select rows in worksheet view and use right click
menu commands. To select entire row - click on the header cell of this row. You can select multiple
row at once by using Shift key.
Use this row command from the right click menu moves selected rows to other worksheet. This
command has 3 options:
Insert before selection - insert new rows before currently
selected rows in other worksheet. If you are using Synchronous Selection option - this
option is usually used.
Overwrite selection - replace rows of the destination
worksheet by selected rows from source sheet.
Insert after selection - insert new rows after currently
selected rows in other worksheet.
Inserted rows are merged exactly in same way - select rows you want to add to other spreadsheet
and use Use this row command.
When rows are added to other sheet, they are removed from difference report and references in
other differences are adjusted.
Delete command from right click menu removes selected rows from sheet. Also it removes
selected rows from difference report and adjusts references in other differences.
Merge added and deleted columns:
Columns are merged exactly in same way as rows. You should select columns by clicking on the column's
header and use Use this column or Delete commands from the right click menu on the
selection.
Using these features you can quickly add or delete rows, columns and cells, find intersection
of 2 spreadsheets and more ...
