View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Cobra Cobra is offline
external usenet poster
 
Posts: 5
Default Separating worksheets into separate workbooks

I have a file with about 100 tabs (worksheets) and would like to save each
worksheet as a separate workbook without going through the move function 100
times. Is there anyway I can do a mass separation of the worksheets?

thanks in advance.