Splitting excel file up by 100's

[Johnny0313x]

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!

[Johnny0313x]

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!