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,