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
Bookmarks