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! |
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! |
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! |
All times are GMT +1. The time now is 11:37 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com