VBA that Finds Matching Cells and Adds Cell Values

[pahickham]

This is a re-post from another site, since I wasn't having much luck on there:

The problem I'm presenting's a little above my VBA skills, so I appreciate any help and ideas. I've pasted a couple of excel sheets to give a general idea of what I'm looking for. Essentially I'm looking for a code that will find matching the "SAP" numbers, when input on the "Received" tab, and add the "qty" from the "Received" tab to the matching "Actual Qty" in the "Inventory" tab. Thanks for any help in advance, I look forward to seeing these ideas!

https://www.excelguru.ca/forums/showthread.php?9767-VBA-that-Finds-Matching-Cells-and-Adds-Cell-Values

 

[mumps]

my pleasure.

 

[pahickham]

@NoSparks
I'm not certain you understood why I added the extra column. I did it because his previous VBA would continue to add data form previous inputs anytime I added a new input, essentially stacking the quantities. I assumed the easiest way to counter that would be to make a new column to mark whether it had already been input to use for the VBA so it wouldn't count the earlier input. That's what I meany by "I intend to keep everything that goes in the received list?"