Jackie

Have you written the Macro or recorded it ?

If you can programme in VBA I can send you a routine that will take a BIG
Workbook and split it various smaller workbooks based upon the generic names
of the worksheets in the BIG Workbook

George

"jackie" wrote:

Hi- I have a macro that currently generates commission statements for my
sales reps into a new workbook based on a list of names. I can either
generate one file with all statements or individual files for each statement.

I would really like to create district workbooks. I have 20 districts, each
with varying number of sales reps. I'd like 20 separate workbooks.

The macro that I currently have looks at column A (Rep Names) to create the
statements. Is there a way to look at column B (District #) to create
separate workbooks.


Right now I have to run the macro for district one. Paste the names for
district two and run again, paste the names for district 3 and run again, etc.

Thanks,