Creating smaller files from one worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an Excel worksheet with roughly 5000 records in it. I want to create
new worksheets with 100 records per worksheet. Is there an easy way to do
this other than cutting and pasting?

Thanks,
 
Back
Top