need to compair two excell docs and find the changes

G

Guest

I have two large excell docs with almost the same info on, i need to see what
changes have been made between the two docs, is this possible ?
 
R

robert111

Yes - create a third large excel doc and in cell A1 put

=if(nameoffirstdoc!A1=nameofseconddoc!A1,"","X")

and copy across spreadsheet.

changes will be marked
 
G

Guest

there are numerous "Compare" add-ins out there for this. Check your copy for
it: Tools > Addins...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Closing documents in Excell & Word 1
Extract specific information from the body of outlook mail to an Excel File using VBA 0
Securing an Excle File? 1
How to display two excel docs at same time. 2
Word Macro to insert text and save as PDF 4
Finding a temp file 3
linking workbooks - Help needed ASAP 6
All open excell spreadsheets close when I click on the big X in the upper right 3

Top