| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I separate a worksheet into many files?
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I separate a worksheet into many files?
Hi Alicia
Try this one http://www.rondebruin.nl/copy5.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Alicia" wrote in message ... 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Backup files in separate directory? | Excel Worksheet Functions | |||
| How do I edit a worksheet and copy to multiple files? | Excel Discussion (Misc queries) | |||
| One worksheet for three separate hair stylists appointments. e.g.. | New Users to Excel | |||
| How do I save sheets in a workbook to separate files? | Excel Worksheet Functions | |||
| Indirect reference from one worksheet to another | Excel Worksheet Functions | |||
Linear Mode
