Good day --
I used the subtotal functions to generate the following report.
What I would to instead of having to insert page break of each group,
is have it generate a new worksheet for each group, and change to tab
name to sales person name?

Any ideas, suggestions, links would be appreciated?

David




Sales Person Month ProdName SalesValue
John Cage Jan Metal Desk 3,100
John Cage Mar Wood Chair 4,500
John Cage Total 7,600

John Smith Jan Wood Chair 4,500
John Smith Feb Metal Chair 1,300
John Smith Mar Wood Desk 5,400
John Smith Apr Wood Chair 4,500
John Smith May Metal Desk 3,100
John Smith Total 18,800

Mary Davis Jan Wood Desk 5,400
Mary Davis Feb Metal Chair 1,300
Mary Davis Total 6,700

Steve Brown Mar Wood Desk 5,400
Steve Brown Total 5,400
Grand Total 38,500