PC Review


Reply
Thread Tools Rate Thread

Copying data from a pivot table

 
 
travis
Guest
Posts: n/a
 
      15th Oct 2008
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 With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Code that will rerun or refresh a pivot table (after new data ispasted into the original Pivot Table's Source Range) Mike C Microsoft Excel Programming 3 15th Feb 2008 06:22 AM
Copying values from pivot table to cells outside pivot table richzip Microsoft Excel Misc 4 16th Jan 2008 11:03 PM
Filter lines containing pivot table and non pivot table data =?Utf-8?B?R3JvdmVy?= Microsoft Excel Worksheet Functions 0 24th Sep 2007 07:20 PM
Copying formulas using Pivot Table data =?Utf-8?B?amhrYXJy?= Microsoft Excel Programming 2 19th Oct 2004 01:19 PM
absolute reference while copying data from the pivot table kim Microsoft Excel Worksheet Functions 0 22nd Jul 2003 01:52 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:52 AM.