+ Reply to Thread
Results 1 to 2 of 2

Getting the Check Register Balance to show on another Sheet

  1. #1
    thenderson
    Guest

    Getting the Check Register Balance to show on another Sheet

    I have been trying to figure this out for a while. My boss has multiple check
    registers on my computer and they are sheet 2,3,4,and 5 on my check register
    work book. My boss wants sheet one to display all their balances. Is their
    anyway to make it automatically update with out have to copy and paste them
    each time I balance them.

  2. #2
    Biff
    Guest

    Re: Getting the Check Register Balance to show on another Sheet

    Hi!

    If these are "typical" check registers then the balance is usually the last
    (used) cell in the right most column. So, you can use a lookup formula for
    each balance:

    Assume the balance is in the last (used) cell in column G of each sheet:

    =LOOKUP(MAX(Sheet2!G:G)+1,Sheet2!G:G)

    Or:

    =LOOKUP(9.99999999999999E+307,Sheet2!G:G)

    Biff

    "thenderson" <thenderson@constructioninnovators.com(donotspam)> wrote in
    message news:8B3EB1D8-C7EC-4EE5-8200-5FF42E81E442@microsoft.com...
    >I have been trying to figure this out for a while. My boss has multiple
    >check
    > registers on my computer and they are sheet 2,3,4,and 5 on my check
    > register
    > work book. My boss wants sheet one to display all their balances. Is their
    > anyway to make it automatically update with out have to copy and paste
    > them
    > each time I balance them.




+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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