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.