When you don't have opened workbooks in xlCompare, this form is a result of pressing the Merge button.
There are several ways, how to open workbooks in xlCompare.
That's all you need to do. xlCompare displays you merged workbooks.
Changes from the left sheet were moved to the right one.
xlCompare merges ALL changes from MINE workbook, into the BASE one. In other words: ALL changes made in the LEFT worksheet is copied into the RIGHT worksheet.
Changes made in the BASE file (right worksheet) are NOT copied into the MINE file (left worksheet).
You can switch workbooks if you want to apply changes to other file.
Use option Mark Changes When Merging to apply color formatting to every changed cell and unique row.
This procedure is the most common way - when all options are determined by xlCompare.
However, you can use full set of xlCompare comparison options to merge your Excel files.
In this case you SHOULD NOT press the Merge button.
Just drop your files into the xlCompare window, and make sure that MINE and BASE workbooks are selected correctly. Switch workbooks, if they are on the wrong locations.
On this step you can:
Now you need to select worksheets and VBA modules to be compared and merged/
After pressing Compare button on the dialog, described above, you get comparison results.
Now you see which cells will be merged from MINE workbook into the BASE one.
This will start merging operation.
All changed and unique cells will be moved from left workbook into the right one.
xlCompare is able to perform all types of merge operations you encounter on the daily basis. This tool allows to merge workbooks in single click and to select and preprocess data before merging.
In any case this operation is quite simple and requires only a few second.
Download and install the latest up-to-date version of xlCompare. The download is a full-featured version.
Current Version: 10.2.0
Build Date: 10/12/2021
If you are still thinking if xlCompare is worth to try - please review long features list on the page below.
During 10+ years, our team has been working to provide for you a robust and quality software. It boosts your productivity and saves you time and money. Just look into our list of changes on the page below to imagine the amount of work done on the product.
The most of the modern computers have 64-bit processors, which give you significantly more calculation power and other benefits. But if you have an old PC with 32-bit processor, please download xlCompare 32-bit using the link below.