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" (donotspam ) wrote in
message ...
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.