Divide data into portions
 

Hi Everybody :-)

Is to count how many rows of data there is, if it can't be divided b
15 then it adds the additonal rows of data containg xx so that it ca
then be divied by 15. i.e if the total rows is 28 it adds to extra row
so that it can be divided by 15.

Then i need it to cut and patse data into a sepaarte file. i.e. th
total numbers of rows containing data is 30 so 15 goes into it twice
So the first two rows are saved into a file named 1.xls then the next
rows are saved into a file named 2.xls and so on until there is 1
files containing two rows of data.
This needs to work for any mulitple of 15 so if there was say 45 the
three rows would be copied into 1.xls then the next...

My math in vba is not to good

Regards
Pau

--
Message posted from http://www.ExcelForum.com