Check Spreadsheet For Changes

[timbo1957]

Hi,

I am being asked to create a way of checking whether the data in a spreadsheet has changed since the last update. So there will be a spreadsheet with 53 columns of data and around 500 rows that will be saved as for arguments sake Version1. Version1 will then be saved as Version2 and that version will be updated. Then at month end Version2 needs to be checked back against Version1 and a new file called Data Changed created with just the rows where the data is different in Version2 to Version1.

Can anyone suggest the best way to do this?

Many Thanks.

[LJMetzger]

Hi timbo1957,

Two different ways using VBA:
a. Have a 'Log' Sheet that in real time records any changes made in Version 2.
b. Compare Version 2 to Version 1 as follows (assuming no row or columns shifts):
(1) Look at each non-empty cell in Version 2. Determine whether the cell is the same or different from the cell in Verison 1.
If the cell was BLANK in Version 1, the cell was added.
(2) Look at each non-empty cell in Version 1. If the cell is BLANK in Version 2, the cell was changed (i.e. removed).

Lewis

[sandy666]

You can use MS Spreadsheet Compare Tool (2013 - 2016) or Spreadsheet Inquire (2010) or Spredsheet Compare from Sourceforge