Can I create multiple pages in pivottables

[dji]

When using a pivot table I have a table of 20 product groups with the product groups in the filter dropdown and the respective data on the page. Is there a way that the 20 product groups can be reflected in 20 sheets to save on the copy and paste . thanks

 

[rconverse]

When using a pivot table I have a table of 20 product groups with the product groups in the filter dropdown and the respective data on the page. Is there a way that the 20 product groups can be reflected in 20 sheets to save on the copy and paste . thanks

Look into "show report filter pages" in MS Help. If you setup the product groups as a report filter and then make that selection, a page will be created for each product group. Steps depend on the version of Excel.

HTH,
Roger

 

[dji]

i am using excel 2007 thanks