i have a file that is 10,000+ lines and need to break it every 900 lines into a new file. Is there a way in excel to accomplish this?
i have a file that is 10,000+ lines and need to break it every 900 lines into a new file. Is there a way in excel to accomplish this?
Hi
Create a sub folder called split990 in C drive and try the following macro codes.
RaviPlease Login or Register to view this content.
Ravi,
Thanks for the code - One more thing is it possable to have the header in Line 1 copied to each new file in line one?
HI
try the following modification. Change ski.xls to the current file name. A1:Z1 to the range of header length.
RaviPlease Login or Register to view this content.
That is fantastic - THANKS
where in the macro should I put code to rename "Sheet 1" on each file it saves?
Hi
insert the code in bold as shown
RaviPlease Login or Register to view this content.
Thank you very much
ravishankar this is amazing. I appreciate your time with this, it is going to help me tremendously. Are you aware of anyway to name these outputs.I need to have a internal file number that just has an auto incrementing file number?
@phenicie
Welcome to the Forum, unfortunately:
Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Welcome to the Forum, unfortunately:
Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks