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?