Hi,

I am reconciling two sets of transactions in Sheet 1 and Sheet 2. And I wanted to be able to transfer those transactions that do not match to a new sheet.
I need to match two columns in Sheet 1 and Sheet 2, one is the reference # and the other one is the transaction type.
The columns in Sheet 1 are C and F and in Sheet 2 it's columns K and S.
If everything matches, a message box will pop up and if there are non-matching transactions, it will create a Sheet 3 with the transactions from Sheet 1 and Sheet 2 that do not match.
I have been reading in this forum for quite some time, but can't find a vba that matches what I need.


Thanks,

Crista