VBA to copy and paste data (selections based on a string)

[Wunderbarre]

Hi gurus,

I have a worksheet that updates dynamically. The IDs comes in Column H and the data in columns J,K, and L. I need to find all the IDs that have the letters "AC" in them and copy data from J, k, L columns ( of the same row as the ID with AC). After copy, it has to insert the data as rows in another table in Columns AK(ID column) Row 38 onwards and columns AM, AN and AO (Row 38 onwards). The screenshots show the requirements.

Thanks.

Note that there will be data after the pasted Rows.

 

[alansidman]

Are you pasting to the same sheet? Or a different sheet?

What does this mean?

Note that there will be data after the pasted Rows.

Does it mean that the pasting requires that new rows be inserted at Row 38 or that the data is pasted into the next empty row after row 38. Please clarify what you mean.