Trying to fix my budget worksheet

[LadyRogue]

I'm trying to figure out a formula to make my budget easier to use. Basically, I've set it up that when I make a deposit or payment, I document it under a specific category such as food or rent, etc. and it subtracts it from the set amount I have on budget worksheet. But now I want to set it so I can make note of deposits, but as I withdraw or spend money, the deposit amount goes down. For example: The first row will be Deposit and it will add up as I deposit money into my account and document my deposits. The next row will have a set amount for my rent and as I spend money, it subtracts from that amount. Once the set amount is spent, it should subtract from the next row and so on. I'm basically trying for a cascading effort. I set a max value and when it hits that number, it moves to the next row. The reason I am doing this is to keep better track of how much is in the bank and how much I'm spending.

How should I go about setting this worksheet up? I already have a template budget set up, but I can't figure out how to get the cascade working. Thanks!

[brokenbiscuits]

If you could maybe post the template you have, that might give a better visual explanation of what you're trying to acheive, because you've completely lost me.