Copy rows between "STARTCOPY" & "ENDCOPY" and insert in another worksheet

[mikeop99]

I've been wrapping my brain around this macro. I have a worksheet that has "STARTCOPY" & "ENDCOPY" down the A column. I am trying to have a macro that will search down column A ->Find "STARTCOPY" -> Offset down 1 -> Select that row to "ENDCOPY" offset up 1 -> Copy -> Insert Rows in page "paste" at row 28.

So on the "Active Sheet" it will copy the rows between "STARTCOPY" & "ENDCOPY" and insert them in the "Paste" sheet.

Is this doable? I have an example worksheet attached.

Many Thanks
Mike

[rcm]

Please Login or Register  to view this content.