Automatic splitting of data to several files

  • Thread starter Thread starter Marcus Ahlbäck
  • Start date Start date
M

Marcus Ahlbäck

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Splitting Data from One Worksheet to Many Automatically 3
Split a worksheet into multiple worksheets of the same Excel file 1
data splitting 1
how to use countif to incorporate filters 1
How to consolidate data from different files? 2
How do you copy all data in a row only if value in column A is "xy 1
Help with a formula (Multiple lines to sum and return if) 2
Macro to split workbook into several based on cell contents 3

Back
Top