Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional functions on portions of cell data | Excel Worksheet Functions | |||
Locking portions of a formula | Excel Worksheet Functions | |||
Divide one row over other row I dont wont to divide one number | Excel Discussion (Misc queries) | |||
Copying portions of data | Excel Discussion (Misc queries) | |||
how do you divide one row of data by another row and have the tot. | Excel Worksheet Functions |