Compare Two worksheets in same workbook

SaiSantosh274

New Member
Joined
Nov 16, 2021
Messages
6
Office Version
  1. 365
Platform
  1. Windows
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
 

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

SaiSantosh274

New Member
Joined
Nov 16, 2021
Messages
6
Office Version
  1. 365
Platform
  1. Windows
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
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,133
Messages
5,835,594
Members
430,369
Latest member
pingel

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top