Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying data from a pivot table
I've got a pivot table which produces similar output to this:
RepA RepB RepC 2006 4 $49.96 5 $729.81 6 $649.07 7 $527.03 8 $122.36 9 $529.81 $541.62 10 $734.83 $520.40 11 $6.31 $453.44 12 $453.81 $286.63 2007 1 $713.53 $782.00 2 $417.29 $263.83 3 $554.24 $841.09 4 $791.51 $111.28 5 $247.09 $296.89 6 $884.56 $732.85 7 $568.78 $576.68 $594.44 8 $647.52 $38.64 $108.34 9 $259.49 $72.78 $358.13 10 $544.96 $943.36 $578.56 11 $862.21 $108.69 $129.16 12 $575.78 $225.86 $373.74 2008 1 $327.81 $346.06 $98.61 2 $942.12 $238.45 $906.00 3 $162.99 $971.45 $999.47 4 $82.75 $574.36 $380.54 5 $657.61 $538.89 $463.01 6 $313.50 $195.83 $262.31 7 $688.89 $319.32 $614.25 8 $604.99 $632.96 $45.17 9 $611.30 $707.56 $954.69 10 $723.28 $175.69 $611.20 The formatting looks screwed up but essentially what I'm trying to portray here is a pivot table covering the period April 2006 to October 2008 with production data from three different workers. Each of these columns need to be copied into different spreadsheets for working out how much each worker needs to be paid. Manually I would use the mouse, highlight the first column from July 2007 to October 2008, copy, then go to the pay sheet, put the cursor on July 2007 and paste special/values. Then I'd highlight the second column from September 2006, copy then paste into the pay sheet at the insert point Sept 2006. Then I'd do the same for the third column, starting at April 2006. I'm just not sure how to go about selecting those ranges in a pivot table like this. Travis |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying pivot table | Excel Discussion (Misc queries) | |||
Copying values from pivot table to cells outside pivot table | Excel Discussion (Misc queries) | |||
copying pivot table results to a new sheet. | Excel Programming | |||
Copying & Pasting from Pivot Table | Excel Discussion (Misc queries) | |||
Copying formulas using Pivot Table data | Excel Programming |