Can I quickly split up worksheets into different files?

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combining data from multiple worksheets into one 4
Split screen 4
Copy Graphic to Multiple Worksheets 2
Import Multiple CSV Files from Same Folder into Open Workbook 5
moving worksheets 1
Worksheet Tabs Dissapear 4
Clustering worksheets 1
Merge data from different worksheets 3

Top