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

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

Thanks!

Yeah you're right I'm an absolute newbie in VBA (or programming), so I guess
I just have some homework to do.

"joel" skrev:

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

See
http://www.rondebruin.nl/copy5.htm#workbook

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




"Marcus Ahlbäck" wrote in message
...
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