My son is trying to track his expenses in Excel 2003. I am trying to help him so he doesn't have to copy and paste manually his expenses from the expense sheet into the checking worksheet. If the bank column has I in it then copy that expense to the Intrust expense. If the bank column has B in it then copy that expense to the Bank of America expense.
The expenses will be a running expense meaning that he will not be deleting the values once moved to the appropriate bank.
The test file is attached.
Bookmarks