Thread: Splitting excel file up by 100's

I am trying to split up an excel file that has 18000 lines, i want to break this into groups of 100 lines and retain the original header info on line one for each file. Is this possible to do with a macro. I have NO experience with macros of programming so go easy on me. It would be great if it could autosave as book 1 book 2 book 3 or whatever, file name doesn't matter that much. Just breaking apart manually is so boring and annoying. Thank you!

anyone Ive researched so much and come up empty handed....im ready to offer more then i should for an answer...if you no what i mean lol!