View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
dlw dlw is offline
external usenet poster
 
Posts: 510
Default save the ind workshts in a workbk as separate workbks automatical

right click on the tab, move or copy, select new book off dropdown, check
make copy if you want to preserve the original workbook

"Kueck" wrote:

I need to take a large workbook that has several worksheets, and save each
worksheet as an individual workbook, maintaining links if possible. I know I
can do this manually, but would like to do it as automatically as possible.