How to combine 2 price lists using xlCompare
This is common task - you have 2 pricelists and you need to
combine them into single list to add new records and analyze
how the numbers was changed.
How xlCompare can help you?
xlCompare has set of quick time-saving commands, accessible from the main Compare button:
- Compare
- Merge
- Update
- Remove Duplicates
- Get Duplicates

All commands take pair of worksheets (workbooks) as input. Your pricelists should be on the different worksheets.
Merge command, compares both sheets and updates values from left worksheet with
values from the right one. New rows and columns from right worksheet are added to the left sheet.
All modified cells are highlighted with colors.
For example:
Pricelist 1:
Code | Price | Description |
Item 1 | 100 | Description 1 |
Item 2 | 200 | Description 2 |
Pricelist 2:
Code | Price | Description |
Item 2 | 150 | Description 2 |
Item 3 | 300 | Description 3 |
As an output of the Merge Worksheets command you'll get the following new list:
Code | Price | Description |
Item 1 | 100 | Description 1 |
Item 2 | 150 | Description 2 |
Item 3 | 300 | Description 3 |
As you see this list contains all records and all changed values.
You can calculate difference of the changed values and analyze how the price was changed.
Is this feature only for pricelists, or I can use it for another tasks?
We don't focus only on pricelist operations. This is common database-style operations,
like INNER, OUTER JOIN and INTERSECTION. You can use these command to work with
accounting statements, customer lists, ... They can be used anywhere with 2 worksheets
which has database style (list of records).
Download xlCompare 2017
Version: 4
Download Size: 3.3 Mb
File Name: xlCompare.msi
Order xlCompare 2017
License: Perpetual
Price: USD 99.99
Evaluation Period: 30-days
xlCompare is a powerful and handy utility! Visit Download Excel Compare page to try it now.