I have a simple table, checkbook register on sheet1. However, on sheet 2, I am trying to display the records that have not been checked off.
columns are:
date, payee, chk#, debit, credit, balance, r
As the records are reconciled, an x is placed in column "r".
For the records that do not have an x in column r, I would like to have those records displayed on sheet 2.
I'm trying to do this without writing vba.
Bookmarks