Check register running balance to another worksheet
 

I have a workbook with multiple check register worksheets and I want to recap
the running balances on a separate worksheet. I want the recap sheet to
reflect the updated running balance of the check register after an entry is
made. Does anyone know how to do this?

Check register running balance to another worksheet
 

Not enough detail.

If your registers are setup like a typical paper check register then the
current balance is the last numeric value of the balance column.

Assume your balance column is column F.

This formula will return the *last* numeric value from column F:

=LOOKUP(1E100,F:F)

--
Biff
Microsoft Excel MVP


"Marysam67" wrote in message
...
I have a workbook with multiple check register worksheets and I want to
recap
the running balances on a separate worksheet. I want the recap sheet to
reflect the updated running balance of the check register after an entry
is
made. Does anyone know how to do this?