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
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).
xlCompare is a powerful and handy utility! Visit Download Excel Compare page to try it now.