Macro to fill cells from Sheet 1 to Sheet 2 if match

Dear all,

please kindly have a look at the attached before and after workbooks.

The task is to fill data on Sheet 2 in Columns B and C if it finds the particular "Sendungsummer" on sheet "Ship"

Thank you!

try

Please Login or Register  to view this content.

Thank you jindon! Works very well. I had to reopen the other thread, where you helped greatly. Can you have a look?

https://www.excelforum.com/excel-pro...-and-fill.html

I noticed that on repeat it deletes previous entries. Can this be changed in the code? I use this macro every day with the text file. But it needs to leave the data entries from previous imports untouched.