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

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

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