I have set up 3 sheets in Google sheets in related to budgeting/expenses.
The first contains the full budget (say Sheet A for example); The second contains the individual expenses (Sheet B); and the Third contains the pivot table (Sheet C), which helps to group together all the different expenses from Sheet B into categories (say for example Category A, B & C)
The pivot table is used to separate all the expenses into their relevant category and provide a sum total of the amount spent within that particular category. I want to copy this sum total amount to Sheet A (under the column 'Requested')
At first, I set a simple formula ='Sheet C'!C8
But the problem is, every time I add a new expense to Sheet B, the sum total value in the Pivot Table sheet (Sheet C) will be moved down to say C9 and so on. Is there some kind of formula I can use to copy the sum total value to Sheet A?
Bookmarks