Excel Workbook data spliting into multiple workbooks

[premsaradhi]

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

 

[premsaradhi]

Hi all,

I have an excel workbook having some huge data.

I need to split the master workbook into separate workbooks. The splitting of data should take place whenever it finds an empty row.(splitting spot).

And I want the newly created workbooks to hold

1) A filename with serial number (Ex: BV0001, BV0002, BV0003,... and so on.
2) Same header from master file should be pasted in all new files
3) In all new files data must pasted be in "Sheet1".