Excel 2007 : Printing Subtotalled Data To An Excel File

[Rick K]

Good Morning!
I have a data file that I subtotal by sales rep. It just shows rep name, customer, sales, commission rate, commission etc. - pretty straight forward.

I subtotal by sales rep, add totals to sales, commissions, etc., AND, I put a page break between each rep, which allows me to print a seperate report for each rep.

I'd like to do the same thing, but only print each sales rep's data to a seperate spreadsheet file, so that I can email it to each rep.

Never heard of this before, but is there a way to do this? I've attached some dummy data, subtotalled, etc.

Any ideas are always welcome!

Thanks,
Rick