Hi,
I am looking to program an excel spread sheet for budgeting. I will have a column of weekly spending in column A, and I would like to be able to put in my paycheck amount into a cell, have the spreadsheet subtract my allowable spending budget from that amount, then have my total money left over be transferred to another cell in which it will be cumulatively added with each subsequent paycheck. I was wondering how to create a macro that can reference a value in another cell (lets say the total balance left over after my budget is subtracted from my paycheck) and will cumulatively add the values from that cell each time I put in a new paycheck value. I'm not sure if I'm explaining it well enough, but I would like the "paycheck amount" cell to reset back to zero after putting in the amount, so that it is ready to receive another value from a subsequent paycheck. With that value resetting back to zero each time, I would need a macro that can remember the past value from my "remaining balance" cell and add each subsequent value to the past value with each paycheck entry. In other words I would need a cell that has a running total which references the value placed in another cell and retains that total when the reference cell is reset back to zero.
I have no idea how to make macros, so any help is appreciated.
thanks
Bookmarks