Try this example
http://www.rondebruin.nl/copy5.htm

Use
http://www.rondebruin.nl/copy5.htm#workbook


--
Regards Ron De Bruin
http://www.rondebruin.nl



"Doug Lowe" wrote in message .. .
I have a workbook with one sheet that has about 2,000 rows. The data consists of project management information, with the project
manager's name in the first column. I want to create a macro that will create a separate workbook for each project manager so the
project manager can see only his/her projects. Thus, if there are 20 manager names, the macro will create 20 workbooks, one for
each manager.

I have a lot of programming experience and know Word VBA but not much Excel. Any suggestions on the best general approach to this
problem? Thanks,

--Doug