Hello,
I am trying to create a monthly budget sheet. It consists of 2 sheets. The first sheet consists of 2 columns - column EXPENSE_TYPE and column AMOUNT. An example:
EXPENSE_TYPE | AMOUNT
Travel 1007$
Food 300$
Utilities 54$
The second sheet is listing all the transactions that I made during particular month, so it has columns of DATE, EXPENSE_TYPE and AMOUNT. An example:
DATE | EXPENSE_TYPE | AMOUNT
20190901 Food 23$
20190902 Utilities 15$
20190903 Travel 315$
20190903 Food 22$
My goal is to bind the EXPENSE_TYPE and AMOUNT columns in Sheet1 and Sheet2, so that when I fill in data in Sheet2, the AMOUNT column with appropriate EXPENSE_TYPE row in Sheet1 is automatically updated. In my given example above, you can see that in Sheet2 there are 2 rows of Food expenses. So the sum of these expenses (23$ + 22$ = 45$) should automatically be calculated and displayed in Sheet1 column AMOUNT and row Food.
How can I do it? And maybe you could tell how this thing that I want to implement is called officialy? Binding? Referencing? Something else?
Thank you