Compare and find differences between two rows of data

Hello,

I have a problem that I need help with.

I need help creating a macro, that will look through 2 different sheets in excel, and find if there are differences between data. The data in the 2 sheets might not be aligned perfectly, so it will have to look through that.

Sheet 1 will contain:
A*********************B**************C***
Bryant, Alan***********ELT12(4)*******1FN236KLM
Doe, Jane************124AHB*********1DNG90236
Handcock, Joe*********E0042(7)*******FNG2334(7)8
Lancy, Jason**********1XFTXS********RGT3222(S)6
Smith, John***********126ZLT*********MGT2454S5

Sheet 2 will contain
A*********************B**************C***
Bryant***************ELT12(3)*********36KLM
Handcock************E0042(6)**********334(Z)8
Lancy***************1XFTXS***********222(5)6
Smith****************126ZLT***********454S5

What I am looking for is that the data in "( )" should be bolded since they are not the same, and possibly highlight the cell
*note that colum C has the same last digits, but does not contain all of them
*note that sheet 2 only contains Last Names
*note that sometimes the person might be missing completely from the Sheet

Originally Posted by dilipandey

Hi Lakeshow,

welcome to the forum.

I believe this can be handled in more simpler way if you wish to compare the results.
I can give you a formula solution where a new column on the right side of the data will say "yes" if entire record is matching - let me know if you are comfortable. thanks.


Regards,
DILIPandey
<click on below * if this helps>

Yeah that would be great as well. Thanks in advance for your help.