Check register running balance to another worksheet

  • Thread starter Thread starter Marysam67
  • Start date Start date
M

Marysam67

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?
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Running Balance in Access 1
balancing check register 2
Getting the Check Register Balance to show on another Sheet 1
Ref in two worksheets 1
Transaction Classifications in Checkbook 6
Exclude worksheet from loop. 0
Checkbook Register and Budget Worksheet 0
Help with this Macro 3

Back
Top