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
<!-- / message --><!-- edit note -->
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
<!-- / message --><!-- edit note -->