How to run a macro to split 20k files into files of 100 rows. leading zero issue too.

spudn56 · May 6, 2020

[FONT=&quot]issue with splitting a large 20k excel file into files of 100 rows keeping header also per file. I also had tried an app but it also removes the leading zero in the zip code field even though I formated the cell named zip code with special-zip. I have very little experience using excel.
Thanks[/FONT]

macropod · May 7, 2020

Cross-posted at: https://chandoo.org/forum/threads/i...files-of-100-rows-including-header-row.44229/
For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184

alansidman · May 7, 2020

also crossposted at: https://www.ozgrid.com/forum/index....rows-i-need-to-save-them-into-new-files-of-1/

How to run a macro to split 20k files into files of 100 rows. leading zero issue too.

spudn56

New member

macropod

Member

alansidman

Member