I have a very large spreadsheet (my working copy) that has 68+/- columns and over 202 +/-(the total columns and rows will vary) rows that I have to maintain. This information has the potential to change on a daily basis.

What I am trying to do is compare the new document with a version that I already have.

I get notified when changes need to be made to my version and I highlight those cells yellow. I then transcribe the corrected info onto another excel doc/send off for updates. Once a week I receive a new updated version. It is very common to get the new version and not all of the updates were made. As you can imagine manually screening both copies ti verify changes is very time consuming.

I want to be able to pull a new version. If the new version matches my working copy (meaning the updates were taken) for it to de-highlight my working copy and add new columns and rows(if the new one has added new columns/rows of information) If the new one doesn’t have a record on my working copy then please highlight that column/rows first column red.

I hope that this is something that you can help me with. If you can’t do this exactly then can you please suggest something similar to help me get to the result I am seeking?

I have zero experience in VBA so please explain in detail.

FYI I am using Excel 2007. If I can’t use excel is there any other 07 Programs that I can use?

Thanks
Mike B