I have rows in Sheet 1 that I want to filter into two other Sheets.

Rows with the word "To" in Sheet 1 should be filtered into Sheet 2.

Rows with the word "From" in Sheet 1 should be filtered into Sheet 3.

Basically, Sheet 1 looks like a bank statement.

Sheet 2 is the Payments area for a Cash Flow chart.

Sheet 3 is the Receipts area for a Cash Flow chart.

So Sheets 2 and 3 must automatically break down Payments and Receipts so they can be calculated seperately.

My question is how do I create a sheet that filters select content from one sheet to another?

This is something I have never done before and I don't know where to start.

Thanks.