• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to compare two different sheets for changes

sunil

New Member
Hi,


I ma required to update a contigency plan for my tasks every month that includes various information like my processes names, location, hours for operation, my team members responsible to handle those tasks, doc number etc... In short, it is a huge list of data. Every mnth I send my changes to the previous mth's data . However, I notice that that not all changes suggested by me is incorporated in the list. As a result, I have to go through the entire sheet next mth that wastes my time. Is there a way to check this by referring to the document that I sent during the last run and what I have received this mth and confirm the changes.
 
Hi Sunil ,


Will the changes only be in individual cells , or can it be that rows or columns will be added / deleted ?


If the worksheets only need to be compared on a cell to cell basis , it is much simpler.


Narayan
 
Back
Top