Hi everyone,
Please help me to split 1 excel master file into many smaller ones by rows.
The master file contains header (10 first rows) + 90 information lines. I want to split it into 90 smaller excel files, each one contains header + 1 information line.
No words can describe my gratitude for you.
Attaching a sample workbook enables others to work on your problem:
To attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.
Click on GO ADVANCED and click "manage attachments" to open the upload window.
To add a file to a post
Hi everyone,
Please help me to split 1 excel master file into many smaller ones by rows.
The master file contains header (10 first rows) + 90 information lines. I want to split it into 90 smaller excel files, each one contains header + 1 information line.
No words can describe my gratitude for you.
Thanks davesexcel for guidance.
When you say that you want each smaller file to contain the header, do you mean the first 9 rows? What name do you want to use to save each file? What is the full path to the folder where the new files should be saved?
You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
Practice makes perfect. I'm very far from perfect so I'm still practising.
Hi Mumps1
Yes, header in each smaller file = 9 first rows in master file
The name for each smaller file is: "HBG IPD 201901" + "cell C" (from the information line)
They all should be saved in the same folder with the master file
Copy/paste this macro in a standard module in the master workbook and run it from there.
Please Login or Register to view this content.
Dear Mumps1,
Grateful for your help
Though this macro got into some problems as below. Could you please help me?
Capture.PNG
Dear Mumps1,
Grateful for your help
Though this macro got into some problems as below. Could you please help me?
Attachment 604285
Dear Mumps1
I have figured it out
Thank you
You are very welcome. I'm glad it worked out.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks