VBA to find, copy and insert mulitple copied rows (newbie)

Hello all,

I am trying to create a macro to find a group of rows, copy and them and insert them above the existing rows.

In column A, I need to find the cell containing the text "Insert new projects". Then I want it to copy all of the rows below that until it gets to a cell that says "Summary". Then I want it to insert/paste all of those rows (the ones between "Insert..." and "Summary") above the "Insert..." row exactly as they are.

This could include 10 rows or 30, just depending on the sheet it's run on, but it will always be the rows between (but not including) "Insert New Projects" and "Summary".

Any help would be very much appreciated.

Thanks,
RL

Am I being Thick here?

All you will achieve is to move the row "Insert New Projects" be;ow the row "Summary"

Is that what you want to achieve?

I read it a little differently. Maybe you are looking for this?

Please Login or Register  to view this content.

stnkynts,

That is exactly it!!! It works like a charm. You're my new hero!

I'm trying to learn more VBA but mine is really clunky and rarely error free. I love forums like this where I can get code to study to learn to do it myself next time.

Really appreciate your help!

Randi Lee