I am trying to create a monthly budget sheet. It consists of 2 sheets. The first sheet (Sheet1) consists of 2 columns - column EXPENSE_TYPE and column AMOUNT. Its purpose is to display a total amount spent for each type of expense in a particular month. An example:
EXPENSE_TYPE AMOUNT Travel 1007$ Food 45$ Utilities 54$
The second sheet (Sheet2) is listing all the transactions that I made during particular month, so it has columns of DATE, EXPENSE_TYPE and AMOUNT. Its main purpose is to display a detailed info of each transaction that has been made in a particular month. 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? Cell binding? Cell referencing? Something else?