I have a exel spread sheet with 20k rows I need to save them into new files of 100 rows including header row.

[spudn56]

I have a exel spread sheet with 20k rows I need to save them into new files of 100 rows including header row. I will be doing this quite a bit and copying and pasting won't be a great option.

First Name

Last Name

Phone

Email ID

Address

City

State

Zip

That is the header then I have the 20k of info for those. Which I need to break it up into seperate files of 100 rows. I am new to excel need help.
Thanks in advance

 

[macropod]

Cross-posted at: https://www.excelguru.ca/forums/sho...into-files-of-100-rows-leading-zero-issue-too
Please read Chandoo's policy on Cross-Posting in the forum rules: https://chandoo.org/forum/threads/site-rules-new-users-please-read.294/

 

[AlanSidman]

Also crossposted at: https://www.ozgrid.com/forum/index....to-save-them-into-new-files-of-1/#post1234971

Please read this link: https://www.excelguru.ca/content.php?184