View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
joel joel is offline
external usenet poster
 
Posts: 9,101
Default Automatic splitting of data to several files

that is why there is a VBA (visaul basic programming language) built into
excel. You can write a macro t split the files. It is done all the time.
There isn't really a lot of information you provided to writte the macro.
They are not hard to write. Look at the Excel - Programming postings to see
examples. Look for example like your where there were answers to you will
know how to properly request the macro to be written. It doesn't seem like
you have a lot of programming experience to do the programming yourself.

"Marcus Ahlbäck" wrote:

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