Getting the Check Register Balance to show on another Sheet

[thenderson]

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.

 

[Biff]

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