Referencing Data in a Pivot Table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a pivot table which shows me total money spent in various accounting categories. I want to reference the sums this creates to subtract them from a total budget to give me a remaining total. Unfortunately, as the pivot table is updated, cell references change. This means that the total I used as say total spent on fuel may become total spent on salary.

Can anyone help?
 
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