I have a long data set of thousands of rows. I need to parse the data into separate files of 100 rows each. I can do it by brute force, or with a cut and paste macro, but I was curious whether there is an advanced function that allows me to do this by specifying the target number of rows

Thanks in advance.