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

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