Extract Reconciling Items

[Howardc1001]

I have a sheet called Statement and a and sheet called Purchase Ledger


I have writen code to compare the Reference Number in Col F and Value in Col G on sheet "Statement" with Col F and I on sheet "Purchase Ledger"

Where items on sheet " Statement" does not match sheet Purchase Ledger, then extract to sheet "Statement Reconciling Items"

Where items on sheet "Purchase Ledger" does not match sheet "Statement", then extract to sheet "Purchase Ledger Reconciling Items"


I have manually extracted the data


It would be appreciated if someome could kindly amend my code as it is not extracting the data correctly

Please Login or Register  to view this content.

[Marc L]

According to your attachment an Excel basics VBA demonstration :

Please Login or Register  to view this content.

► Do you like it ? ► ► So thanks to click on bottom left star icon « ★ Add Reputation » ! ◄ ◄

[Howardc1001]

Many Thanks Marc. Your code works perfectly