Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Breaking Into Seperate Files
Is there a way to to program a break into seperate files based on differences
in a column? For instance: Owner Company# Company Name Data Jones 10 My Company 1 Jones 10 My Company 5 Smith 15 Next Comp 3 Smith 15 Next Comp 7 The business need is to break an XLS file with hundreds of pages out by company # with the company number as the file name. I would like run a script that sends all records belonging to a company # to an individual file if it is possible. Thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Breaking Into Seperate Files
Try this Brian
http://www.rondebruin.nl/copy5.htm See the workbook example -- Regards Ron de Bruin http://www.rondebruin.nl "Brian01" wrote in message ... Is there a way to to program a break into seperate files based on differences in a column? For instance: Owner Company# Company Name Data Jones 10 My Company 1 Jones 10 My Company 5 Smith 15 Next Comp 3 Smith 15 Next Comp 7 The business need is to break an XLS file with hundreds of pages out by company # with the company number as the file name. I would like run a script that sends all records belonging to a company # to an individual file if it is possible. Thanks! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Breaking Into Seperate Files
Thanks. I'll give this a try.
"Ron de Bruin" wrote: Try this Brian http://www.rondebruin.nl/copy5.htm See the workbook example -- Regards Ron de Bruin http://www.rondebruin.nl "Brian01" wrote in message ... Is there a way to to program a break into seperate files based on differences in a column? For instance: Owner Company# Company Name Data Jones 10 My Company 1 Jones 10 My Company 5 Smith 15 Next Comp 3 Smith 15 Next Comp 7 The business need is to break an XLS file with hundreds of pages out by company # with the company number as the file name. I would like run a script that sends all records belonging to a company # to an individual file if it is possible. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Breaking notepad file with 1000000 lines to smaller excel files | Excel Worksheet Functions | |||
Unwanted breaking up of print output into multiple files | Setting up and Configuration of Excel | |||
Question on breaking on cell into three seperate | Excel Worksheet Functions | |||
Breaking out individual files from a .xls worksheet | Excel Worksheet Functions | |||
breaking links between excel files when one file already deleted? | Excel Worksheet Functions |