Find different rows in 2 excel worksheets and save them in another Excel workbook
If you have 1 million rows in your worksheets and 300000 of them are different and should be extracted - there is no manual solution for this task. You will spend hours of your time to check these worksheets.
With xlCompare you solve this in a seconds. xlCompare is tool designed to compare excel files, merge (consolidate sheets) commands are important part of the software.
In the instruction below we show you which commands you can use for this task. In the similar way you can solve other business cases which are not described here.