When I download a bank statement onto an Excel spreadsheet, the credits (Receipts) and debits (Payments) come "as one", as shown on the attachment.
However, I want to separate the two different columns and transfer the Credits to a different spreadsheet.
I can do this by painfully "cutting and pasting" every entry, but this is very time consuming. Is there a quicker way, and if so, how do I do it ?

Thanks for any help.

Kuler


Capture.JPG