I would need help in building a macro for the attached example.

There are multiple columns on Sheet 1. I need the macro to identify, if a specific row in column D contains "ABC" then the information in that row should be pasted in sheet 2

In the example sheet, Column D has the unique ID. So as D4 contains "ABC", A4 should be pasted in H3, D4 to I3 and E4 to J3. Then the macro to automatically check the next row to indentify if it contains "ABC".

IF not, move to the next row.

In this case, the next row that has ABC is D6. So as D6 contains "ABC", A6 should be pasted on the next line in Sheet 2 i.e. H4, D6 to I4 and E6 to J4.

I hope I was able to put it right in words..

Attachment 148703