Hello

I have a spreadsheet which I have to reconcile between our customer
orders in the system and our bank account.

I dont know if this requires a complicated if statement but here is
the criteria of what I need,


1. I have a list of transactions from our system and the bank account
in the same sheet.

Column A identifies between the system and the bank accounting using
the characters SYS and BACC.

Column B contains the type of order.

Column C contains the order number which should also match the bank
account.

Column E contains the amount from the bank account and the amount from
the order.

IF the following criteria are met then do the below.

1. Column B match for both rows then column E matches for both rows
then column B. Column A rows much have only one row that matches so
the criteria must be one for sys and one for bacc.

THe above criteria is the only way I think we can match the entries
off completely.

One the criteria has been met I want both rows copied to a new sheet
called "Matched" so the data sheet just leaves entries which have not
been matched up.

Here is some sample data,

ColA ColB ColC
ColD ColE
SYS S A12345LP
DD 100.10
BACC S A12345LP
DD -100.10
SYS D A12345LP
DD 99.99
BACC D BA12345LP
DD 99.99
BACC E 90222EAP
DD 120.00
SYS E 444555BAP
DD 12.00
SYS S B12345AA
DD 89.97
BACC S B12345AA
DD 89.97

If the criteria I set is applied then I would expect to see copied
into the new worksheet "Matched" the below transactions which have
been matched off.

There must be an entry for both SYS and BACC regardless as to whether
the amounts are positive or negative as long as they match to the
penny.


ColA ColB ColC
ColD ColE
SYS S A12345LP
DD 100.10
BACC S A12345LP
DD -100.10
SYS S B12345AA
DD 89.97
BACC S B12345AA
DD 89.97

Me even getting the thinking in my head correct was
difficult.........I really hope someone can help with this,

Thanks so much,

Your all really amazing at these things and I do appreciate all your
help.

Andrea