Compare data from two worksheets and highlight differences in active sheet

[harman83]

Respected Experts,

Kindly help me to create macro where I can Compare data from two worksheets and highlight differences in active sheet.

In sheet attached -
I want to run macro on Sheet 1 and highlighted ones are the cells values which are different from sheet 2.

I want to compare each cell in each row of data,
Like sheet 1 A1 to be compared with Sheet 2 A1
Like sheet 1 A2 to be compared with Sheet 2 A2
:
:
:
Like sheet 1 B15 to be compared with Sheet 2 B15

Sheet1.xlsx


Thanks,
Harman

[jindon]

Please Login or Register  to view this content.

[harman83]

Thanks Jindon...You are a rockstar....If your time permits...Kindly help me on this one also..

http://www.excelforum.com/excel-prog...ml#post4239603