Pivot Table data output on multiple sheets

  • Thread starter Thread starter Sean
  • Start date Start date
S

Sean

I would like to know if there is a way to automatically get Excel to
create the same pivot table on several sheets with each sheet showing
a selection of the data.
For Example
On one sheet the pivot table which relates to the male
and
Another sheet the pivot table relating to the females
 
You can use the Show Pages command to create multiple Pivot Tables:

Move the Gender field to the Page area
Select a cell in the Pivot table
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

about pivot table 1
Pivot Table - Changes 5
Pasted Pivot Table looks at old sheet 1
Pivot Table 2
Adding to an existing Pivot Table 7
Pivot tables - memory issues - please help 2
Pivot table data source 1
updating pivot table 1

Back
Top