T
travis
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
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