Hi,
I'm looking for a VBA Code that can help me to split master data into multiple workbooks by row count.
The sheet has about 50k rows and needs to split by 150 Rows into each workbook
Row 1 to 5 is basically the header and needs to be there in every sheet including the formatting & spacing.
Row 6 onwards is where the data starts and needs to be split into batches of 150 rows
For Example
Row 6-155 = 150 Rows split into a new workbook with the header from Row 1 to 5
Row 156-305 = 150 Rows split into a new workbook with the header from Row 1 to 5
and so forth
Any help would be appreciated.
Thank you.
I'm looking for a VBA Code that can help me to split master data into multiple workbooks by row count.
The sheet has about 50k rows and needs to split by 150 Rows into each workbook
Row 1 to 5 is basically the header and needs to be there in every sheet including the formatting & spacing.
Row 6 onwards is where the data starts and needs to be split into batches of 150 rows
For Example
Row 6-155 = 150 Rows split into a new workbook with the header from Row 1 to 5
Row 156-305 = 150 Rows split into a new workbook with the header from Row 1 to 5
and so forth
Any help would be appreciated.
Thank you.