Use Pivot Table data in formula

  • Thread starter Thread starter tmc
  • Start date Start date
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
 
You can use the GETPIVOTDATA function to extract data. Look in Excel's
help for information and examples for your version of Excel.
 
Back
Top