ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Moving all worksheets (https://www.excelbanter.com/excel-discussion-misc-queries/94150-moving-all-worksheets.html)

jerredjohnson

Moving all worksheets
 

I have around 40 worksheets in my current workbook. Is there a fast way
to move all worksheets into there own seperate workbook?


--
jerredjohnson
------------------------------------------------------------------------
jerredjohnson's Profile: http://www.excelforum.com/member.php...o&userid=32236
View this thread: http://www.excelforum.com/showthread...hreadid=552245


Ron de Bruin

Moving all worksheets
 
Hi jerredjohnson

Use this code example
http://www.rondebruin.nl/copy6.htm


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



"jerredjohnson" wrote in message
news:jerredjohnson.29g5qp_1150380606.1195@excelfor um-nospam.com...

I have around 40 worksheets in my current workbook. Is there a fast way
to move all worksheets into there own seperate workbook?


--
jerredjohnson
------------------------------------------------------------------------
jerredjohnson's Profile: http://www.excelforum.com/member.php...o&userid=32236
View this thread: http://www.excelforum.com/showthread...hreadid=552245





All times are GMT +1. The time now is 05:57 PM.

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