I have a report that is currently done in Excel manually. The report goes to 10 people, there is a line on the report for each person. 10 copies of the report are printed, one name is left on each report while the other 9 are deleted. Is there a way to print 10 copies of the same report having only one name show on the report and the other 9 records show without names?

Example:

Person 1 10 sales $100
15 sales $150
20 sales $200
-------------------------
10 sales $100
Person 2 15 sales $150
20 sales $200
-------------------------
10 sales $100
15 sales $150
Person 3 20 sales $200

Thanks for your help.