VBA Code to Split Master Data into multiple workbooks by Row Count

KaranM

New Member
Joined
May 29, 2020
Messages
14
Office Version
  1. 2019
Platform
  1. Windows
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.
 
Hi

I need some help to update the code.

The platform has updated its template and the earlier code needs some modification. I tried to do it myself but couldn't figure it out.

Recap:

Split a workbook with "x" number of rows to workbooks with rows of 150.
Have included the initial code in the google drive

New Mods:

Format of the template has changed where the fixed rows/headers was the first 5 rows while the new one is the first 3 rows
The number of rows to split has increased from 150 to 300




In the above google drive I have included:

1> Master Data Sheet
2> Examples of the Split Workbooks
3> Copy of the original code.

Thank you for all the help so far
 
Upvote 0

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK
sorry - unable to help further at the moment
 
Upvote 0
Thanks for the quick reply.

I understand, would appreciate it anytime you can help later on.

Thank you again.
 
Upvote 0

Forum statistics

Threads
1,213,546
Messages
6,114,254
Members
448,556
Latest member
peterhess2002

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top