Excel 2007 - compare two worksheets (duplicate files)

[Matt Carter]

I have a file in two locations. I want to know which is the most up to date
and or compare which information is in both.
They are "identical" in that I THINK they have all the information. I might
have made a change here or there. I want to compare them. Is there a way in
2007 to get document FILE.xlsx and file1.xlsx to be compared to see if line
A1 is different than on File1 and than on file?

They are showing our static IP addresses and I made changes and I SWEAR I
updated the file and yet it did not show up. I have a copy in multiple
locations and I want to ensure that the work I did is updated and all
duplicates are safely deleted without losing data. So file1 has the "best"
data and I can delete file.xlsx, or file and file1 have DIFFERENT data that
can be "merged" together to make a new file or file1 sheet.

Does that help at all?

I am looking to consolidate two or more files into one to avoid having
duplicate and possibly altered information in more than one location.

I am planning on putting it into a sharepoint to avoid this, but I found
multiple files in multiple locations.

Thank you.

Matt

 

[Harlan Grove]

I have a file in two locations. I want to know which is the most
up to date and or compare which information is in both.

....

You can't tell from the files' respective date stamps? How about
opening each, pulling up document properties under the big Office
button at the upper left corner of the Excel application window, and
checking who the last user was who modified the file and when they did
so?

They are "identical" in that I THINK they have all the information.

....

One way to compare values in different cells would be to load both
workbooks, then open an new, blank workbook and enter formulas in it
like the following in the new workbook:

Sheet1!A1:
=IF('[file1.xlsx]Sheet1'!A1<>'[file2.xlsx]Sheet1'!A1,"####","")

This would display #### in cells in the new workbook in which the
corresponding cells in the other two workbooks differ.

There are also macro-based approaches you could find in the Google
Groups archives for the Excel-specific newsgroups. That leads to
another point: for specific help on the main Office applications, like
Excel, post your questions in newsgroups specific to those
applications. For Excel for a question like this, post in either

microsoft.public.excel

or

microsoft.public.excel.misc