Hello everyone,
I am experimenting with an expenses report.
It has a basic form, as described below:
- Rows: Jan, Feb, ...Dec
- Columns: types of Standard Expenses, total "Standard Expenses", other types of expenses, total "Expenses", Income, Savings, Bank Account no.1, Bank Account no. 2, ... Bank Account no. x, Cash.
Each Month-Type of Expense cell contains a formula. (e.g. B2 cell: =1.5+10+19.... etc.)
I would like to automate the procedure of adding expenses to the respective column and deducting from the respective bank account or cash column.
How can I automate that?
I am experimenting with an expenses report.
It has a basic form, as described below:
- Rows: Jan, Feb, ...Dec
- Columns: types of Standard Expenses, total "Standard Expenses", other types of expenses, total "Expenses", Income, Savings, Bank Account no.1, Bank Account no. 2, ... Bank Account no. x, Cash.
Each Month-Type of Expense cell contains a formula. (e.g. B2 cell: =1.5+10+19.... etc.)
I would like to automate the procedure of adding expenses to the respective column and deducting from the respective bank account or cash column.
How can I automate that?
