I have to reconcile my multiple bank account transactions with my system's compiled transactions and need the unique system id against that account no.

I've coded the same but 2 problem arise.

1. If bank transaction are out of my system transactions the system stop running and showing error "object not Found" instead of skipping transaction and moving to next transaction.

2. I have few similar(Amount) transactions in my 2 different accounts for which i need to run "findnext" command but its not working in this as well.

I'm definitely mistaking somewhere pls guide.


Coding:-

Sub Reconciling()

Dim Mycell As Range
Dim Newrange As Range
Dim sys_amt As Range


Set sys_amt = Range("b2", Range("b2").End(xlDown))
Set Newrange = Range("f2", Range("f2").End(xlDown))


For Each Mycell In Newrange


sys_amt.Find(Mycell).Select

If ActiveCell.Offset(0, 1) = Mycell.Offset(0, 1) Then
ActiveCell.Offset(0, -1).Copy Mycell.Offset(0, 2)
Else
MsgBox ("Not Showing")

End If

Next Mycell


End Sub