Excel 2007 : Compare a new document with a version that I already have and de-highlight cells

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

In the old programming days we used to call this "diffs".

Searching the net found http://excel-diff.florencesoft.com/

Search the net for "Excel Diffs" and see what you find. If none of that works for you we'll give it a go.

Originally Posted by MarvinP

In the old programming days we used to call this "diffs".

Searching the net found http://excel-diff.florencesoft.com/

Search the net for "Excel Diffs" and see what you find. If none of that works for you we'll give it a go.

Sir,
Thanks for your quick reply. I am workig for a government agency and I am not sure that they will approve to purchase software from the net like this. Do you know of any other like programs that I would be able to DL for free?

Some guru on the net could most likely write some VBA code to do this, but why reinvent the wheel. If the suff that is out there is in VBA, you can be using it within Excel. Then all you are doing is using Excel.