I have a worksheet with 2,248 different dollar amounts from a checking statement that include Credits and Debits. I have been able to import the data into a workheet containing three columns (date, amount, credit/debit). What I need to do is weed out any amounts that do not have a match so I can research them and see where the offset is. Is there any formula or VBA coding that can do something like this? Get the matched amounts and move them to another worksheet or move the unmatched amounts to another worksheet.So far I have been able to sort by descending dollar amounts. This helps a bit but have to go through the whole spreadsheet and copy/paste and amounts that do not have a match, which is pretty long. If I am not being clear enough, please let me know and I will try my best to make things clearer.