Looking to split a large excel file by rows and keep the header

flyguy

New Member
Joined
Dec 24, 2020
Messages
8
Platform
  1. Windows
I am trying to split up an excel file that has multiple lines, I want to break this into groups of 500 lines and retain the original header info for each file. This file will always have the same header just different amount of lines each time. Is this possible to do with a macro/vba. I have no real experience with macros for programming. It would be great if it could auto save as file1-file2 etc. file name does not matter. Just breaking apart manually is time consuming and looking to see if it can be automated.
The file starts as a .csv and needs to be converted to an .xls

Thank you for your assistance.
 

MoshiM

Active Member
Joined
Jan 31, 2018
Messages
371
Office Version
  1. 2016
Platform
  1. Windows
did that and get compile error and Sub flyguy() is yellow
Sub flyguy()




Dim ACS As Range, Z As Long, New_WB As Workbook, B As Long, _
Any error messages about an ambiguous name?
 

Some videos you may like

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

flyguy

New Member
Joined
Dec 24, 2020
Messages
8
Platform
  1. Windows
Any error messages about an ambiguous name?
There was not. I hate to take up any more of your time and am grateful for what you have supplied.
I can work with the original code that you supplied.
Have a safe and Happy New Year.
 

flyguy

New Member
Joined
Dec 24, 2020
Messages
8
Platform
  1. Windows
Getting an error and the below text is red


Dim ACS As Range, Z As Long, New_WB As Workbook, B As Long, _
I am able to work with the original code. I appreciate your time and help.
 

Watch MrExcel Video

Forum statistics

Threads
1,127,612
Messages
5,625,846
Members
416,138
Latest member
Pizzaman22

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
Top