Pivot report
 

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
--
Just a regular user

Pivot report
 

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

Rockbear wrote:
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


--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com