VBA to compare two worksheets in same book

[Ironman]

Hello all - -

I have a workbook that contains two worksheets. The columns are the same between the two, column A is the Employee ID in both worksheets. The other column headings are: Name, address1, address2, city, state, zip, EmgerName, EmgerType, Cell, Address1, Address2, City, State, Zip.

What I'm looking to do is compare WS1 with WS2 and in WS2, what ever is different from WS1, the font color changes to RED. For example let say for employee number 1234, everything is the same expect for EmgerName and Cell, then these fonts are changed to RED in WS2 so I can identify them quickly.

Thanks for taking time to check this post out, you guys (and gals) are truely very helpful!

[Domski]

A basic example:

Please Login or Register  to view this content.

Dom

[Danexcel]

Thank you. Your response is along the lines of what I wanted. I will study it and ask again as I progress. Thanks!

[Ironman]

Danexcel - - did you post your response to the wrong thread or perhaps you are greatful for Domski answer? I'm not sure...

In any case, Domski - Thanks for your quick reply. I like what the code is doing. But one thing, is there a way to modify the code to do a find of the Employee ID number from one sheet to the other, then see if there is a change? Sheet1 may have a different number of rows than Sheet2. Sorry, but I did fail to mention that, the columns will be the same, but the row count would not.

Thanks tho for you very speedy response...

[Domski]

Sure, I'll have a play and get back to you.

Just to confirm, am I checking all the numbers that appear on sheet 1 against sheet2? Is it possible there may be numbers on sheet2 that don't appear on sheet1? Can these just be ignored if so?

Dom

[Domski]

Try this:

Please Login or Register  to view this content.

Dom

[Danexcel]

Oops I don't know how I made the mistake. I posted to the wrong thread yes sorry!

Well, somehow though I felt it helped me LOL That's a good thing !

[Ironman]

Thanks, that is right on perfect! Thank you very much....

[Domski]

Oops I don't know how I made the mistake. I posted to the wrong thread yes sorry!

Well, somehow though I felt it helped me LOL That's a good thing !

LOL! Cheers for the reputation even if it was by mistake!

Dom