Split Excel file into multiple files based on number of rows

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

Try this on a copy of your workbook

Please Login or Register  to view this content.

Thanks jolivanes. It works I tested it.

Is there a way to schedule this to run as and when new records are added or deleted?