View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ash ash is offline
external usenet poster
 
Posts: 54
Default Copying multiple sheets to new Workbook

Is it possible to "split" mutliple worksheets into mutiple workbooks in a
single function?

For example, if there are 15 worksheets in one workbook that I would like to
"split" into 15 individual workbooks, is it possible to move them all at once
as opposed to performing an individual copy to new workbook for each tab?

Any help is appreciated,
Ashley