+ Reply to Thread
Results 1 to 2 of 2

Register balance

  1. #1
    Registered User
    Join Date
    10-02-2015
    Location
    Western OK
    MS-Off Ver
    2011
    Posts
    1

    Register balance

    So, my question is this...I use a basic checkbook register with a running balance. My workbook has sheet 1 with my monthly budget. It included all bills, personal expenses, and how much goes out of each check. I also have a place where I keep how much each of the 2 monthly checks are minus all expenditures for said check. I would like to be able to have the running balance of two separate register balances on sheets 2 and 3 to display on on sheet 1. I know how to insert it from the current balance on the register, but once i add transactions, I don't want to have to update the formula on sheet 1 to a new reference cell on sheets 2 and 3. Ideally, I would like to have some type of total or balance box at the bottom of each register that updates with the balance so that I have one cell to reference in the formulas on sheet 1. Is this possible?

    I know this I made it sound more complicated that it is, I really just want the balances on the registers to update on sheet 1 when I add transactions. Hope this clarifies.
    Last edited by simplyimperfect86; 10-02-2015 at 05:59 PM.

  2. #2
    Forum Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Register balance

    Just taking a wild guess...

    Do you want the last (bottom-most) number from a column?
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Checkbook register opening balance
    By jrfine in forum Excel General
    Replies: 12
    Last Post: 02-08-2012, 11:36 AM
  2. Excel 2007 : checkbook register opening balance
    By jrfine in forum Excel General
    Replies: 3
    Last Post: 02-07-2012, 01:26 PM
  3. Need formula for a check register (balance column)
    By dlperdue in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-23-2010, 01:47 PM
  4. How do I get balance forward to work in check register?
    By Frieda in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-22-2006, 02:00 PM
  5. How do I get the checkbook register to keep a running balance?
    By gmaw in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-10-2006, 11:40 AM
  6. [SOLVED] Getting the Check Register Balance to show on another Sheet
    By thenderson in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-21-2005, 03:35 PM
  7. [SOLVED] how do i create a running balance on checkbook register
    By mic in forum Excel General
    Replies: 5
    Last Post: 08-04-2005, 04:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1