Thank you in advance
I am looking for an easy way to do this since i have to do it for a number of files. I also do not want to accidently make a mistake.

I want to split an excel file (actually have several), that has 5k records dividing it up every 500 rows a new file. So in the end there is 10 files with 500 records each.