Subtotal Report: Creating new sheet(tab) for each group?
 

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

Subtotal Report: Creating new sheet(tab) for each group?
 

David,

Have a look at the pivot table report. This will generate the report for
you. Putting the sales person's name in the page field.

You then have to do a special process to general a report for each salesman
as follows:
Select the select where the sales persons are and ensure that (all) is
displayed.

Then from the pivottable toolbar menu item (not from the normal tools menu)
select show pages. This will make individual pages for each salesman also
putting the salesmans name in the sheet name.

--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"DavidJ" wrote:

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