View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Ian[_4_] Ian[_4_] is offline
external usenet poster
 
Posts: 85
Default how do I find differences between two open excel files

I think I can offer a partial solution. You can identify what cells have
changed or, if numeric how much the change is.

Your original files are file1 & file2. Create a new file (file3).
If all the values are numeric:
In file3 A1 subtract file1 A1 from file2 A1.
Go to Tools Options View tab and uncheck Zero values.
If the cells are not numeric:
In file3 A1 =(IF(file1 A1=file2 A1),"","Changed")

In each case the changed cells will be obvious, either with Changed or the
difference between the values.

This will only work if the changes have not altered the layout of the sheet
(ie not inserted or removed cells).

Ian

"Gary" wrote in message
...
I'm trying to determine the differences and changes made between two
different files to capture that the correct changes were processed