Copy variable amount of rows between Start and End to Start

Hi All,

I'm new and I don't know much about VBA code.

What I want to do is this:
I have multiple Start and End sheets, Start/End, Start1/End1,start2,End2, with different amount of sheets with different purposes between them.

From the sheets between Start1 and End1, I want to copy the rows always starting from row 30, row 29 is the header, with a variable amount of rows below.
In Start1 the copied rows have to start at row 9.

How do I do this.

Thank you in advance for your help!

Where should the data be copied to?

Do you want similar copy paste to be done for the other types of start-end sheets as well?

Could you upload a sample of your file?

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

Hi Arlu1201,

It could also work for my sheets between Start and End.
But I want it definitely for the sheets between Start1 and End1.

The Summary should be on sheet Start1 and on sheet Start, because I think there will be to many sheets if I do that on a separate summary sheet.

Thank you!


CG hulpsheet_test macro.xlsm