moving the entire column CHECK# to be immediately to the right of the column AMOUNT.
locate all the RECORD TYPE entries that contain ATM.
We want ATM to be changed to DEBIT or CREDIT based on the dollar value in the column AMOUNT. When ATM appears in RECORD TYPE, and AMOUNT is >0, change ATM to CREDIT. When ATM appears in RECORD TYPE, and AMOUNT is <0, change ATM to DEBIT.
we need the to sort column RECORD TYPE by DEBIT and CREDIT. Then make two new tabs in the spread sheet, One for DEBITS and the other for CREDITS.