running total cell macro

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

Submit a copy of your workbook

So I will put my paycheck in the "paycheck amount" cell. The "total remaining balance from paycheck" cell will be C1-(C4:C12), and I want the "total account balance" cell to be a running total of each value from C13. C13 will be reset to zero after each paycheck is entered, so my "total account balance" cell will retain previous values from C13 as well as add subsequent values entered to the previous values of C13. My goal is to have the "total account balance" cell reflect what's in my bank account to some extent.

thanks

Almost all of this could be done using formulas but since you asked specifically for a macro I will do it that way. I would like to add that there are already thousands of free templates out there which are already set up and look really nice which you could use. I personally would use one of them.

Sub Calculate_Money()
Dim rPaycheck As Range
Dim rRemaining As Range
Dim rTotal As Range
Dim rBills As Range

Set rPaycheck = Range("C1")
Set rRemaining = Range("C13")
Set rTotal = Range("C16")
Set rBills = Range("C4:C12")

rRemaining = rPaycheck - Application.WorksheetFunction.Sum(rBills)
rTotal = rTotal + rRemaining

End Sub

Note: Having the merged cells like you have complicates things. Merged cells and macros don't work well together. More reason to actually use formula.