More Excel assistance please!

[Luke]

I have dozens of Excel spreadsheets that contain 60,000 rows.
I need to break each one down into 6 10,000 row spreadsheets.

Can anyone suggest a way to do this that isn't manual?

cheers

 

[Cobertizo]

Why do you need those spreadsheets like that in the end? Depending on what the spreadsheets are for, there may be a different way of getting to the right end result. Hopefully. Because I can't think of much other than some VBA to help you, and I can't code! Have you tried recording a macro? Not sure how they deal with creating new documents, but could be worth a shot...