Macro to Subtract values Where Ref is the same and Values do not sum to Zero

[Howardc1001]

I have data on sheets "PL recon items" and "Statement Recon Items"

Where the Ref in Col F on sheet "PL recon items" is the same as Item ID in Col F "Statement Recon Items" but the values in Col I on sheet PL recon items" is the not the same as the Value in Col G on sheet "Statement Recon Items", subtract the value Col G on sheet "Statement Recon Items" from the value in Col I on sheet "PL recon items" and insert the difference in Col I on sheet "PL recon items" . The row containing the Ref Number and Value in Col G on sheet Statement Recon Items" is to then be deleted


I have shown the results manually in new sheets "PL Result" and "Statement Result"

It would be appreciated if someone could provide me with code to do this