Hi,

I have an excel file containing 9000-10000 rows. I want to split this into multiple files of 1000 rows each.

There's a small condition to this. Say that the number of records is around 9400 (not exactly 9000 or 10000).Then I want 9 files containing 1000 each and a 10th file with these 400 rows. Basically, if the records increase it should push it to the last file, untill it reaches a 1000 and then create a new file.


Any help is much appreciated. Thanks a lot!

- KC