Dear Experts ,
This may be a bit of challenge , but going by the help that i have received i am hopeful that someone can pick this up !
What i have is a excel file containing thousands of rows of question answers with the first row containing titlles
What i want the macro to do is keep the titles in row 1 constant and create a separate excel workbook for every 100 rows and store it in the same location as the parent workbook
Say i have a folder on the desktop called XYZ containing this input workbook say test 1 containing more than 1000 entries
what i would be wanting the macro to do is then split a 1000 Row workbook into workbooks containing 100 rows each and save it in the same folder ...they can be named run 1 , run 2 ,run3 etc
In each of this run books , i want the header row containing the titles same as in the parent workbook and then the rows to appear
After the 100 rows in each workbook , i want "END " to appear in cell A1
it is quite possible that some sheets may have 1000 , some 30000 or some 456 entries
So , if the progarmming can be done such that it counts the total number of rows and then splits in equal 100 numbers and what remains as balance in the last trial workbook , it would be nice
For example if there are 356 rows , we can have trial 1 ,2,3 containing 100 rows each ( excluding the title and end in A1 ) and trial 4 containing 56 rows
Then each trial 1 ,2,3,4,getting saved in the same folder where the 356 row file was originally there would be great ,
I attach a sample input and output file of how things would be simulated !
It is a bit tough , i know and i would be glad if someone can attempt it !
The parent folder with the file eager to be executed shall be on the desktop
Humble regards ,
Amlan Dutta
Bookmarks