I have a spreadsheet of sales reps w/ sales, comision paid, etc.
I currently copy the sheet to a new book (taking header/footer also) &
delete all rows except the ones for a specific rep & save that book to
e-mail to the rep. I have to do this for every rep so it is a little
time consuming. Is there a way to do this on auto pilot?

You could fully automate this, you have to set up soame code to get
the save fuction right, but...you might be able to reduce you time,
with out write to much code, use the macro recodred to repated comman
steps.

Good Luck
ROss