ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Separate Spreadsheets (https://www.excelbanter.com/excel-worksheet-functions/21001-separate-spreadsheets.html)

Sharon

Separate Spreadsheets
 
I have a workbook with ~40 individual spreadsheets. Now I am moving them all
individually and spending tons of time. Is there a way to separate each
spreadsheet into its own workbook at the same time?

Ron de Bruin

Try this
http://www.rondebruin.nl/copy6.htm



--
Regards Ron de Bruin
http://www.rondebruin.nl



"Sharon" <Sharon @discussions.microsoft.com wrote in message ...
I have a workbook with ~40 individual spreadsheets. Now I am moving them all
individually and spending tons of time. Is there a way to separate each
spreadsheet into its own workbook at the same time?





Hi
Have a look he
http://www.rondebruin.nl/copy6.htm
Hope this helps.

--
Andy.


"Sharon" <Sharon @discussions.microsoft.com wrote in message
...
I have a workbook with ~40 individual spreadsheets. Now I am moving them
all
individually and spending tons of time. Is there a way to separate each
spreadsheet into its own workbook at the same time?





All times are GMT +1. The time now is 06:41 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com