Pivot report

R

Rockbear

Hi
I have made a pivot report in one sheet, and gouped them in zip codes and
weight. This grouping takes some time, first with the zip adn the the weight.

I have 10 sheets that have the data placed in the same column, is it in any
way possible to copy the pivot from sheet 1 to sheet 2 using sheet 2 numbers?
I am using excel 2003

Rock
 
D

Debra Dalgleish

Copy the pivot table to sheet 2
Right-click on the pivot table on sheet 2
Click on PivotTable Wizard
Click Back
Select the range on sheet 2, and click Finish
 

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

Pivot Table 2
Pivot from all sheets 1
Pivot Table - Changes 5
Pivot Table group levels 3
Code to add gridlines to Excel Pivot Tables 0
Referencing a pivot tables Grand Totals Column 1
do i use countif? 2
Pivot Table Help 1

Top