Merging two excel sheets via a macro

Good Morning!

I need help ASAP and would really appreciate any feedback.

I have got two sheets, one WK 44 with 2000 lines, and ten columns, and another sheet WK 43 with 1000 lines and 20 columns (the extra ten have got manual information added).
Each of them have the same 10 columns, and there is one column which contains a unique key which is same for both sheets,

I need a quick way to merge these that if any of the WK 43 unique ID match the WK 44 unique ID, another sheet is produced with the 10 extra columns, leaving the other cells blank.

Can someone help me please?

Kind Regards,
Maria

Hi,

read ASAP the yellow banner at the top of this page (see forum rules too) …