Macro to Compare Excel Spreadsheets

0 Comments
Editor Ratings:
User Ratings:
[Total: 0 Average: 0]




Reconciliation on Fire is a free software to compare Excel spreadsheets. This is a free macro spreadsheet for Excel which allows you to compare data from two different spreadsheets in order to find differences and inconsistencies between the two.

This free Excel comparison macro can be used to find typing errors primarily, but also in accounting when you need to go over numbers from two different accounts to make sure that everything’s OK and reconciled.

Reconciliation on Fire default window

When you download this free Excel spreadsheet comparison utility, the only thing that you’re gonna get when you open up the downloaded spreadsheet is what can be seen in the top left corner of the image above. Single button, which when clicked is going t open up the actual control windows, which can be seen in the bottom right corner. Any range of columns and rows can be compared, they can be arbitrarily set using the Range 1 and Range 2 buttons.

Key features of this Excel Comparison Macro are:

  • Free and very easy to setup: you just need to open a macro spreadsheet
  • Compares and finds differences in data between two spreadsheets
  • Detects differences in values, typing errors, wrongly inserted dates
  • Color indicators: lower values and higher values get different markers
  • Compare data from any column or row: they can be manually setup

Like we said, this free spreadsheet comparison macro will mostly be useful to accountants who are working with large amounts of spreadsheets and data, especially during reconciliation, which is basically a comparison between two different sets of data, like for example bank statement and personal budgeting slip, to see if there are any differences between the two. Let’s see Reconciliation on Fire in action.

Similar software: Spreadsheet CompareLazar Lookup.

How to compare data from two different Excel spreadsheets with Reconciliation on Fire

Open up both of the spreadsheets that you want to compare and of course Reconciliation on Fire spreadsheet. Macros have to be activated in Excel, otherwise this free data comparison utility will not work. Click on the Run button, and then fill out both of the ranges from each of the spreadsheets where you need to compare data.

Reconciliation on Fire opening ranges

Simply left click and drag to cover the range, you should see values change in the Enter Range window. Do this for each of the two sets of data that you’re interested in comparing. When you’re done, the Compare Range 1 to Range 2 button from the main menu will become clickable, click it, and wait for a few seconds for Reconciliation on Fire to do the comparison and find the differences.

Reconciliation on Fire comparison done

Green and red colors are pointing out differences, green means that the value of the cell is bigger than it’s counterpart. You’re also gonna see a report with all the differences which were detected, see at the top of the image above. To fix errors, do what you would normally do, double click on the cell, and enter the proper value to reconcile them.

Conclusion

Reconciliation on Fire is a very powerful tool, which is gonna save you a lot of time that you would normally spend on flipping through spreadsheets looking for differences between them, to make sure that there are no errors. This is just a spreadsheet, there’s no installation, just open and run, which is a great plus. Free download.

Editor Ratings:
User Ratings:
[Total: 0 Average: 0]
Works With: Windows, Mac
Free/Paid: Free

Leave A Reply

 

Get 100 GB FREE

Provide details to get this offer