LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.misc
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



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Find the differences in 2 columns Bec[_2_] Excel Discussion (Misc queries) 2 April 5th 07 01:34 PM
How do I find the differences in two spreadsheets ritalc Excel Discussion (Misc queries) 0 February 15th 06 04:31 PM
i couldn't open my excel files,it gives location couldn't find err Hozefa Excel Discussion (Misc queries) 1 December 21st 05 04:06 PM
Find differences between two Excel workbooks or worksheets savage_planet Excel Discussion (Misc queries) 0 September 19th 05 09:27 PM
How do I find differences between two excel worksheets? jfurneaux New Users to Excel 1 March 10th 05 02:05 PM


All times are GMT +1. The time now is 08:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"