Insert rows if value doesn't exist

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

This may work if there are no numbers like A123 and B123.

Please Login or Register  to view this content.

Hi!

Thanks a lot for a reply. Unfortunately, there can be situation where number sequence is the same but first letters different.. Any idea hoe this can be solved?

Thanks!