split worksheet into multiple files by every 25000 row

[deedee]

Hi,

I would like to split a worksheet with about 350000 records into multiple
files by every 25000 rows automatically. Is it possible and how?

Thanks

 

[joel]

YoYes, but you will need a very simple macro. i need more info to write a
macro.

1) Do yo want it split between multiple workbooks or worksheets?
2) How do you want the new sheet/book named?
3) Is it eactly split every 25,000 lines or is there some data point in the
file you want to split? For example if you had Last Names maybe you want
last names starting with A-C in the 1st sheet/book.
4) How many header rows do you have a the top of your original worksheett
and do you want the header rows copied onto the new sheet/book?