| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "A pivot table report cannot overlap another pivot table report" | Excel Worksheet Functions | |||
| Formatting Pivot Report | Excel Discussion (Misc queries) | |||
| print a pivot report | Excel Discussion (Misc queries) | |||
| Pivot report will not fit on sheet | Excel Discussion (Misc queries) | |||
| A pivot table report cannot overlap another pivot table report. | Excel Discussion (Misc queries) | |||
Linear Mode
