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.
 

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

Similar Threads

Pivot tables 2
Subtotal percents in pivot table 1
new to using pivot tables and excel 6
Excel 2000 Pivot table in Excel 2007 5
Average of Subtotals in Pivot Table 0
Pivot Tables 1
Pivot Table Totals 1
Referencing a pivot tables Grand Totals Column 1

Back
Top