Macro to identify a unique value in a column to copy and paste value to another sheet

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

Hi Watersev,

It did work.. HOwever, that was a example sheet and on my real workbook there are many more columns. As in the example, column A, D & E will be copied, how, can I change which columns needs to be pasted to which column in the new sheet??

Hi Watersev,

Thanks for the explanation.. I tried but it seems im not entering the correct combinations.

I need the below columns to be copied

ColumnA
ColumnC
ColumnE
ColumnH
ColumnJ
ColumnM
ColumnT

Can you help??

Hi watersev,

I got the combination at last..

It is

Please Login or Register  to view this content.

Thanks alot for your help..

For me as a beginner I really appreciate your help and you really deserve a reputation... :-)