Dear all,

Maybe someone could help me with the below.
I have two sheets of data.
Let's say:
Sheet1 Column A:
A123
B962
B973
C921
C922
C924
C925

Sheet2 Column A:
A123
B965
B973


I would like macro to search if value from Sheet2 Column A exists in Sheet1 Column A.
If not, then it should insert row in Sheet1 appropriately.
From our example:
A123 - exist
B965 - doesn't
B973 - exist.
Macro should pick up B965 and insert row after B962 and paste value B965 to the inserted row.

Any chance this could be achieved? Thank you!

Kind Regards,
S1n1