| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I quickly split up worksheets into different files?
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can I quickly split up worksheets into different files?
Hi amithere
See http://www.rondebruin.nl/copy6.htm If you want to mail them see this templates http://www.rondebruin.nl/mail/templates.htm Or a macro http://www.rondebruin.nl/mail/folder1/mail5.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "amithere" wrote in message ... 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! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can I quickly split up worksheets into different files?
Thanks so much. You're a life saver!!!
"Ron de Bruin" wrote: Hi amithere See http://www.rondebruin.nl/copy6.htm If you want to mail them see this templates http://www.rondebruin.nl/mail/templates.htm Or a macro http://www.rondebruin.nl/mail/folder1/mail5.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "amithere" wrote in message ... 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! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can I quickly split up worksheets into different files?
You are welcome
-- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "amithere" wrote in message ... Thanks so much. You're a life saver!!! "Ron de Bruin" wrote: Hi amithere See http://www.rondebruin.nl/copy6.htm If you want to mail them see this templates http://www.rondebruin.nl/mail/templates.htm Or a macro http://www.rondebruin.nl/mail/folder1/mail5.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "amithere" wrote in message ... 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! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can I quickly split up worksheets into different files?
On Friday, April 18, 2008 5:09:19 PM UTC-4, Ron de Bruin wrote:
Hi amithere See http://www.rondebruin.nl/copy6.htm If you want to mail them see this templates http://www.rondebruin.nl/mail/templates.htm Or a macro http://www.rondebruin.nl/mail/folder1/mail5.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "amithere" wrote in message ... 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! Ron Found your macro today. Many thanks for sharing it. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Separate/Split all the worksheets in a workbook into different fil | Excel Discussion (Misc queries) | |||
| How to quickly check any error for opening excel files? | Excel Discussion (Misc queries) | |||
| split one excel into two files. | Excel Discussion (Misc queries) | |||
| Split worksheet into new files | Excel Discussion (Misc queries) | |||
| Can I split up an excel spreadsheet into multiple files by rows? | Excel Discussion (Misc queries) | |||
Linear Mode
