Using excel VBA to transfer data from one sheet to another

Hi all,

So I am attempting to transfer the data in one sheet dependent on an the ID which is in row A of both sheets

I want to transfer data that is displayed like A1- ID-B1 Code C1-Code in sheet1

to a table in sheet 2 that has the ID down Column A and the IDs along row 1
I want the data to be displayed as "x" to show which IDs match with which code.

I have not yet found a successful way to execute this

any advice would be greatly appreciated

Hiya, so up to Column K is already there and I just want to add on from Column K

Thank you so much, how would you adjust this so that it only inserts crosses if the IDs across the 2 sheets match?