Macro to compare column and copy & paste the data between 2 worksheets

Hello Guys,

I need help to create a Macro which compares the “Customer ID” column in attached both files (Sample1.xlsx and Sample2.xlsx).

If same “Customer ID” is found in Sample2.xlsx file then value present in “Chassis No.” column against that customer id get copied into the “New Chassis No. 1” column of Sample1.xlsx file.

If same “Customer ID” is found again in Sample2.xlsx file then value present in “Chassis No.” column against that customer id get copied into the “New Chassis No. 2” column of Sample1.xlsx file.

For more understanding, please refer the Columns marked as an Yellow in Sample1.xlsx file.

Any help will be appreciated a lot.

Thanks,

Hello Manish, Find attached !

you need to have both books open!
if you have different workbook and sheet name then do edit code.

Please Login or Register  to view this content.

Click "*" add rep icon in the bottom left corner of my post if this helps!