View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Poorvi Poorvi is offline
external usenet poster
 
Posts: 6
Default Creating multiple workbooks

Is there anyway I can use information on an excel worksheet to create
multiple files? I have data on say 'Tab1'. I have subtotalled data by cost
centers. Can I get a new file created in excel for each cost center ? Can I
have a naming sequence assigned to this?