Use Pivot Table data in formula

T

tmc

I have a pivot table that changes based on the "Job
Number" value I choose in the PAGE section of the pivot
table. I have a formula elsewhere on the spreadsheet
that picks up the value from the "Amount" column of the
pivot table. Problem is that when I change the "Job
Number" in the pivot table the external formula gives me
the #REF! error because it is still looking for the data
from the previous job. Any way to change that external
formula to a relative formula so that it picks up the
current amount in the pivot table instead of erroring out
when I change the "Job Number" value?

Hope this is clear enough.

Thanks
 
D

Debra Dalgleish

You can use the GETPIVOTDATA function to extract data. Look in Excel's
help for information and examples for your version of Excel.
 
Top