Carry a balance to new worksheet

[payday]

Hello all! I am hoping someone can help me with a little issue I am having. I have an excel spreadsheet that I use as registers (like a check register) for all of my bank accounts in order to keep my accounts balanced. I have 7 different bank accounts. In excel, one worksheet has a register for each different bank account. The register keeps a running balance of the accounts for me. What I would like is to create a new worksheet that I can go to and see what the current balance is for each of my accounts. I want this new sheet to update when debits and credits are added to the register.

I have attached an example of the excel spreadsheet to provide a better idea of what I am working with. If you have any advice, I would appreciate any assistance in building this.

[BigBas]

The way I would do it is to have a balance total for each bank account at the top (right under Check Register - 1, for example). That cell can add all the debits and subtract all the credits to keep a running balance. Next, you can directly link the cells to the summary sheet.

[payday]

I thought about that, but I couldn't figure out what formula to use to figure the balance for each account. Any suggestions? I found the spreadsheet as a template somewhere and I just want to make a few changes to better suite my needs.

Thanks for the reply!

[sglife]

Here is the formula for Bank1

Please Login or Register  to view this content.

You need to do the rest