Report

How to Compare two workbooks and see if data has moved or not?

Ask a question hoosier1851 - Last answered on Jun 19, 2017 at 11:45 AM by TrowaD
Hello, I would like to preface this by saying thank you in advance.

I'm interning and one of my superiors has asked me to compare workbooks These workbooks are updated monthly and she wants to see the changes in them month over month. Not only that, she wants to know where what data values went where on the sheet Ex: "Need to know if location PNC00123 moved from line 234 in the August Sheet to Column 266 in the Sept sheet."

She wants to know if a cell was added, moved to another section, or dissappeared. I have no idea how to get this data for her. I've tried the spreadsheet compare offered by Mircosoft Office but that doesn't fulfill what sh's looking for. If anyone knows how to do this please let me know, I have to do this for 8 different workbooks. Thank you in advance.

Helpful
+0
plus moins
Hi Hoosier1851,

Maybe something like this:
http://www.online-tech-tips.com/ms-office-tips/track-changes-in-excel/

Best regards,
Trowa
Leave a comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!