| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating separate workbooks based on filter
I have a workbook that shows:
AgencyID AgentID OrderID DateOrdered - etc. This workbook can contain 5,000 rows sometimes or sometimes 10,000. I'd like to find existing code that steps through the workbook - and creates separate workbooks based on critera. Critera could be one or more fields. The idea is be able to email individual workbooks containing that persons data. Thanks, Brian |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Creating separate workbooks based on filter
Hi BerkshireGuy
Start here http://www.rondebruin.nl/copy5.htm For mail code see http://www.rondebruin.nl/sendmail.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "BerkshireGuy" wrote in message ups.com... I have a workbook that shows: AgencyID AgentID OrderID DateOrdered - etc. This workbook can contain 5,000 rows sometimes or sometimes 10,000. I'd like to find existing code that steps through the workbook - and creates separate workbooks based on critera. Critera could be one or more fields. The idea is be able to email individual workbooks containing that persons data. Thanks, Brian |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I get separate workbooks in separate windows | Excel Discussion (Misc queries) | |||
| HOW DO I CALCULATE SEPARATE WORKBOOKS INTO ONE? | Excel Worksheet Functions | |||
| filter data from 10+workbooks and display in separate workbook? | Excel Discussion (Misc queries) | |||
| how do i get my workbooks in separate windows? | Excel Discussion (Misc queries) | |||
| WorkBooks In Separate Windows. | New Users to Excel | |||
Hybrid Mode
