Compare two sheets and difference to display

Hi,


Can anyone help on this VBA scenario.


I have two sheets Sheet1 & Sheet2. I want to compare two sheets and to display the difference rows and columns of each cells in the sheets.


Sheet2 data willbe in any random order compare to sheet1.Please refer sheet2 datas.


Scenarios:


1. I have to identify and display the missing Row from sheet1. Please refer "Missed Row SeqNo from Sheet1" header.


2. I have to identify and highlight the Srefcol Data changed which i have highlighted in yellow in sheet2.


3. I have to identify and highlight the SrefActive Data changed which i have highlighted in yellow in sheet2.


Can anyone please help on how to achieve this!




Regards,Raj

Hi and welcome
what have you already tried? Where did it go wrong?

Im totally new to this. If let you know any logics, will be more useful