Thread: Detach different WORKSHEETS in one WORKBOOK into DIFFERENT WORKBOOKS
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Positive Positive is offline
external usenet poster
  
Posts: 37
Default Detach different WORKSHEETS in one WORKBOOK into DIFFERENT WORKBOOKS
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

Reply With QuoteReply With Quote