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.
xlCompare has set of quick time-saving commands, accessible from the main
Compare button:
- Compare
- Merge
- Update
- Remove Duplicates
- Get Duplicates
See screenshot below:
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).