Move rows to sheet based if row contains certain string value

[aaelex]

Hi all

Wondering if you could help. I have seen other older threads here but couldn't get them to work for me.

I have a bank statement I am importing via CSV into Excel.

Example data (Sheet 1) is in the following format:

Date

Description

Amount

Balance

<colgroup><col><col><col><col></colgroup><tbody>
</tbody>

20190201

CREDIT INTEREST

145.6

70124.2

<colgroup><col style="mso-width-source:userset;mso-width-alt:2346;width:55pt" width="73"> <col style="mso-width-source:userset;mso-width-alt:17109;width:401pt" width="535"> <col style="mso-width-source:userset;mso-width-alt:2730;width:64pt" width="85"> <col style="mso-width-source:userset;mso-width-alt:2858;width:67pt" width="89"> </colgroup><tbody>
</tbody>

<style>table { }td { padding-top: 1px; padding-right: 1px; padding-left: 1px; color: black; font-size: 12pt; font-weight: 400; font-style: normal; text-decoration: none; font-family: Calibri, sans-serif; vertical-align: bottom; border: medium none; white-space: nowrap; }</style>

20190201

TRANSACTION CHARGE SEE CHARGE STATEMENT DETAIL

-250

69874.2

<colgroup><col style="mso-width-source:userset;mso-width-alt:2346;width:55pt" width="73"> <col style="mso-width-source:userset;mso-width-alt:17109;width:401pt" width="535"> <col style="mso-width-source:userset;mso-width-alt:2730;width:64pt" width="85"> <col style="mso-width-source:userset;mso-width-alt:2858;width:67pt" width="89"> </colgroup><tbody>
</tbody>

<style>table { }td { padding-top: 1px; padding-right: 1px; padding-left: 1px; color: black; font-size: 12pt; font-weight: 400; font-style: normal; text-decoration: none; font-family: Calibri, sans-serif; vertical-align: bottom; border: medium none; white-space: nowrap; }</style>
I want to move/organise the data into seperate sheets based on the description value above.
E.g If cell contains "INTEREST" move to a sheet called INTEREST.
E.g. If cell contacts TRANSACTION CHARGE move to a sheet called TRANSACTION CHARGE etc.

I want it to delete the source row after it has run. So move and not copy.

There are quite a few checks I want to do on the statement and sort into respective sheets (INTEREST, TRANSACTION CHARGE ...etc)

Thank you so much for your time in advance!

 

[aaelex]

Noted thank you!