premsaradhi
New Member
- Joined
- Feb 7, 2023
- Messages
- 8
- Office Version
- 2007
- Platform
- Windows
Dear sir/madam
I have an excel file with huge data, and that data should be breakdown into multiple files with a series of filenames (Ex.BV0001,BV002,BV003......BV9999). but inside of each file the data should be pasted in sheet1 and we are not to change sheet name. Leave it as "Sheet1".
Condition for proper breaking of data is:
Whenever there is an empty row. There the excel should break and create a file with name BV0001 in sheet1.
Same repeats till the end of the data.
1.Header should be common in all files.
2.sheet name "Sheet1" in all excel files
Please help me
I have an excel file with huge data, and that data should be breakdown into multiple files with a series of filenames (Ex.BV0001,BV002,BV003......BV9999). but inside of each file the data should be pasted in sheet1 and we are not to change sheet name. Leave it as "Sheet1".
Condition for proper breaking of data is:
Whenever there is an empty row. There the excel should break and create a file with name BV0001 in sheet1.
Same repeats till the end of the data.
1.Header should be common in all files.
2.sheet name "Sheet1" in all excel files
Please help me