Referencing Data in a Pivot Table

B

Brian

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