Compare Workbooks

Arafat

Board Regular
Joined
May 3, 2011
Messages
61
Hi all, I need a macro to compare two workbooks and return the difference values in new workbook.
Workbook1:
Column1 Column2
DM 1234
DM 4454
DM 5666
DM 7777
DM 5676
DM 5656

workbook2:
Column1 Column2
DM 1234
DM 4454
DM 5666
DM 7777
DM 5676
DM 5656
DM 6757
I need a macro which will search workbooks by the first column value and if it finds difference then it shud return entire difference row in new worksheet.i have many similar values in column1.Kindly Help:smile:
<!-- / message --><!-- edit note -->
 

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

Forum statistics

Threads
1,224,606
Messages
6,179,866
Members
452,948
Latest member
UsmanAli786

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
Back
Top