I'd like to know if I can automate a process using excel to make my personal budgeting easier.
Currently I have a spreadsheet that has my:
budget line items,
how much money from my bi-weekly pay gets attributed to each budgeted item, which I call my "account" for each item.
an account balance which is the sum of my bi-weekly contributions from my pay, minus the sum of my monthly expenses
Sample based on fake numbers below:
a b c d e f g H
|Budget line item||bi-weekly $||Acct balance||Jan ||feb||march ||april||Total spent|
|Food||362||446||640|| || || ||640|
|Utilities||156||168||260||40|| || ||300|
|Bi-weekly earnings||1518|| || || || || || |
| || || || || || || || |
The formula in "acct balance" looks like this"=(B3+B3+B3)-SUM(D3:G3)"
What I'd like to automate is the addition of the "B3" into that formula ever time I get paid. Currently I got through and manually add it in. My real budget has several rows and this is super time consuming, boring, and annoying.
Is there a better way? Advice on what topics to learn about or a solution are really appreciated.