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

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" <berkshireguy2005-(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
>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
>