0

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?

Thank you

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.