Screen Shot 2015-02-04 at 2.28.59 AM.png

Hey All,

Would love your help on figuring this one out... I'm creating a receiving macro for work that allows me to to scan in part numbers and mark them as received once the expected match what was scanned in, rather than doing it by hand on paper. The problem I am running into is that sometime there are multiples of the same part (Column D) under different External Deliveries/POs (Column C) and my macro can not differentiate the External Deliveries and tells me to "Check" the quantities.

Layout of the Work Sheet;
- Column F shows how many total I have scanned in (F2 & F3 both show 2, meaning I only scanned a total of 2 because D2 & D3 are the same; it does not mean I scanned a total of 4; same with F4, F5, & F6, Total scan of 7, not 21).
- Column E show how many are expected per delivery.

So, if F2 or F3 (Those numbers will always match because the part number is the same) = E2+E3, then I have received the correct amount of items.

Right now I am having to change all of them manually, (F2 to 1, F3 to 1; so they match E2 & E3) to receive them. How do I make a macro do this for me and adjust the qualities to match even with different External Delivery IDs?

I'm sorry for the winded explanation, but I wanted to give as much information as possible. Please let me know if this makes sense or if you have any questions.

Thank you and cheers!