PivotTable lookup
 

Using Excel 2003
My PivotTable is set up as follows:

RESOURCE NAME TASK NAME HOURS WORKED
name1 task1 ##
task2 ##
task3 ##
name2 task1 ##
task2 ##
ect...

My 'report' I'm running off of this data is set up as follows:

HOURS WORKED
ACTUAL HOURS
RESOURCE NAME TASK NAME PREDICTION WORKED
name1 task1 ##
##(from pivot)
task2 ##
##(from pivot)
task3 ##
##(from pivot)
name2 task1 ##
##(from pivot)
task2 ##
##(from pivot)
(want to pull this
column from Pivot Table)

My question is: Is there a way to pull the task names, that fall under the
resource names, with something like a GetPivotData function? The resource
names stay consistant, but tasks are constantly added/subtracted and I would
like to use a getpivotdata function(or something similiar to this) to keep my
reports list up to date as the PivotTable is updated- rather than manually
enter all this. I have used the GetPivotData function, but can only get it
to pull the task1 that is on the same line as name1. I understand this just
may not be possible but it's worth a shot to see if any excel masters out
there have any ideas for me.

Thanks in advance for any help.

PivotTable lookup
 

I'm confused. Why wouldn't the getpivotdata function work in this instance?
Why would it not be updated when the Pivot Table data is updated? I use this
function all the time (almost on a daily basis right now) and I haven't
experienced any problems with it.

As an alternative, or as a learning experience, you could try Index/Match.
Take a look at this:
http://www.contextures.com/xlFunctions03.html

Regards,
Ryan---

--
RyGuy


"Kohawk09" wrote:

Using Excel 2003
My PivotTable is set up as follows:

RESOURCE NAME TASK NAME HOURS WORKED
name1 task1 ##
task2 ##
task3 ##
name2 task1 ##
task2 ##
ect...

My 'report' I'm running off of this data is set up as follows:

HOURS WORKED
ACTUAL HOURS
RESOURCE NAME TASK NAME PREDICTION WORKED
name1 task1 ##
##(from pivot)
task2 ##
##(from pivot)
task3 ##
##(from pivot)
name2 task1 ##
##(from pivot)
task2 ##
##(from pivot)
(want to pull this
column from Pivot Table)

My question is: Is there a way to pull the task names, that fall under the
resource names, with something like a GetPivotData function? The resource
names stay consistant, but tasks are constantly added/subtracted and I would
like to use a getpivotdata function(or something similiar to this) to keep my
reports list up to date as the PivotTable is updated- rather than manually
enter all this. I have used the GetPivotData function, but can only get it
to pull the task1 that is on the same line as name1. I understand this just
may not be possible but it's worth a shot to see if any excel masters out
there have any ideas for me.

Thanks in advance for any help.

PivotTable lookup
 

My approach would be to fit the prediction data
into the PT, instead of fitting the hour data into
the "report".
Here is how it would look:
http://www.savefile.com/files/1721403