Bank rec v2, deleting matching check #'s

[Jerhansen277]

I asked the mod to delete my previous thread because I now have all the info and actual records (i wont be doing the actual rec im just making the process easier)

I've attached a WS

the 2nd tab is the output of checks written per the general ledger (gl) blank amounts are because the check was voided and the amount was entered as a debit.

-- I need to be able to delete rows for voided checks which is simply matching check numbers and deleting all but the unique numbers.

the 3rd tab is the output we get from the bank for cleared checks. one problem we had was that is ads an additional 3 digits to the front of the check number (for division ID) which have to be removed. I was able to get a function from VBA newbie which does this but if it were possible to simply make a CMD button which created a new column and corrected the entreries using that function that would be ideal as the person doing the rec's does not have a lot of expertise.

--- I need to combine this with the G/L output and remove cleared checks which again is simply removing all matching check numbers, leaving the records with unique numbers.

Idealy this would all be done with one cmd button but I could see it broken up into the following

1) person pastes the cleared checks from the bank, clicks a CMD which creates a column between A & B, and then fixes the check numbers

2) person then pastes that list beneath G/L output and then clicks button which eliminates all the voided and cleared checks (matching check numbers) and leaves the unique records giving her a list of all outstanding checks.

any and all help very much appreciated.