I am trying to balance a checking account in excel. I want to keep three
cells linked to one another, for example check #, Date, and amount from a
registery and then link the comparison to the banks check # while leaving
those three information linked together. For example Banks cleared date,
cleared amount, and cleared check number. I also want the register to adjust
information to match to the bank statement and show a difference between the
two amounts into a new cell.