Compare Two worksheets in same workbook

[SaiSantosh274]

Hi team,
I am very new to vba. I need help in comparing two worksheets which are in same workbook. Instead of going through row by row comparison makes slow for higher dataset. was planning to do it in a way such that we only scan the whole sheet once and write data at once after comparison. we need to highlight data which are not same in other sheet.

expected method : sheet to object to dictionary to object to sheet.

Could you please help me in doing it.
suggest any method which could do comparison of data sets with around 1L rows eg in both sheets

 

[SaiSantosh274]

Hi team,
I am very new to vba. I need help in comparing two worksheets which are in same workbook. Instead of going through row by row comparison makes slow for higher dataset. was planning to do it in a way such that we only scan the whole sheet once and write data at once after comparison. we need to highlight data which are not same in other sheet.

expected method : sheet to object to dictionary to object to sheet.

Could you please help me in doing it.
suggest any method which could do comparison of data sets with around 1L rows eg in both sheets

Method where comparison of larger dataset can be done very quick