PivotTable lookup

K

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top