PivotTable lookup

[Kohawk09]

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.

 

[ryguy7272]

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

 

[Herbert Seidenberg]

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