View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Detach different WORKSHEETS in one WORKBOOK into DIFFERENT WORKBOO

Try Ron's:
http://www.rondebruin.nl/copy6.htm
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Positive" wrote:
Please help.

I have a workbook of about 100 worhsheets. How do I detach these 100
worksheets into 100 DIFFERENT WORKBOOKS without copy/paste and save
manually every single sheet so that they can be 100 independent excel
workbooks.

Many thanks

Lan