How do I separate a worksheet into many files?

G

Guest

I have a list of data, company names with values and the subtotal for each
company. I would like to make a separate file for each company. Company
Names are listed in column A, one company may appear numerous times,
depending on how many corresponding values it has. So it says company x
however many times in column A, and then it says Company X total. Then it
says Company Y however many times, then it says Company Y total, etc. Right
now all of the information is in one worksheet, but there are like 300
companies (therefore, I need 300 files.) Is there any way to do this?
 

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

How to group all data from 1 column into several columns 2
How to group all data from 1 column into several columns (Redo) 2
Referencing Multiple entries in a worksheet 1
How do I combine these columns into one? 2
How do I compile data? 4
How to calculate percentage of values of subtotals 5
How do I create a small array from a larger one? 3
Stacked Columns (two separate companies, 3 time periods) 1

Top