View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Marcus Ahlbäck Marcus Ahlbäck is offline
external usenet poster
 
Posts: 3
Default Automatic splitting of data to several files

Hello

I have an excelfile with sales-statistics for the entire company.
Is there any "automated" way to create separate files for, for example,
sales person or region (which the would contain a subset of the data in the
"masterfile"). I have all the data nescesarry for the split in my file
(salesperson/region) but I would like to avoid a lot of boring work with
filter-copy-paste-save-as.

Kind regards Marcus