Can I quickly split up worksheets into different files?

  • Thread starter Thread starter amithere
  • Start date Start date
A

amithere

My excel files usually have 50 worksheets (tabs). Each sheet needs to be
distributed to a different person as an electronic file. I keep an original
file so I can do mass updates. Right now, I'm clicking on each sheet and
saving a copy to a "new book" and then saving each new file. Is there a way
to split up all the worksheets into separate "new books" or do I have to
continue to do it one at at time?

Also, is there a way to alphabetize the worksheet tabs (sort) other than
dragging them to move them?

Thanks!
 
Back
Top