Filtering content from one spreadsheet to show it in another

[Dom2012]

I am creating an Excel spreadsheet designed to manage my company's accounts.

Spreadsheet 1 is used like a bank statement to show payments going in and out of the company's bank account.

Spreadsheet 2 is used as a cash flow chart. The sheet sis divided into left and right. Columns on the left are used to list payments. Columns on the right are used to monitor receipts. In both cases, this information is copied from Spreadsheet 1.

I want to find a way to automate this process.

Both the left and right hand columns in Spreadsheet 2 should check rows in S1. If a transaction is a payment, the left-hand side of S2 should automatically add it. If a transaction is a receipt, the right-hand side of S2 should automatically add it.

But how do I get S2 to check S1, add each row in S1 to the correct side in S2?

I realise this may be too simple a description to answer my question. But if anyone thinks they can help me find a way to do this, I would be very happy to answer any questions you might have that would help you to help me figure this out.

Thanks.

 

[Dom2012]

The following two links provide images of what I have done.

The first shows the Accounts spreadsheet (S1). This is the sheet from which S2 should collect and filter rows.

http://s1002.photobucket.com/albums/af141/Praxino/?action=view&current=Accounts.jpg

The seocnd shows the Cash Flow spreadhseet (S2). It should organise the data automatically in the manner shown (but without the gaps).

http://s1002.photobucket.com/albums/af141/Praxino/?action=view&current=CashFlow.jpg

How do I do this?

Thanks.