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