Comparing spreadsheets

[22strider]

Hello Friends

Is there a way to compare two spreadsheets for changes and get the changed cells in original sheet highlighted?

I have two spreadsheets; one is the original sheet that we sent out for some modifications. And the other sheet is the modified one. Both have about 1000+ records. I need to compare the two sheets and highlight changes. So that I can put two sheets side by side and see the change (with highlighted changes).

Thanks for your time.
Rajesh

 

[22strider]

Thanks for helping.

Now I am getting "Application-defined or Object-defined error"; when I click Debug following line gets highlighted:

lc = Range("A" & Columns.Count).End(xlLeft).Column

 

[kpark91]

Try this then

lc = Cells(1, Columns.Count).End(xlToLeft).Column

 

[22strider]

Works fine for me; thanks. The only thing that I want to point out is that for some reason the code assumes 0 (zero) and blanks as a match.

Thanks for your help again.