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