That's just what I need to get going, thanks a million.

--Doug

"Ron de Bruin" wrote in message
...
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