Macro to check total quantities

I have a spreadsheet that tracks what we buy, when we buy it, when it comes in and how much it cost.

If we order a part and we get a partial quantity we record only the partial receipt. I need a macro that looks at the total quantity ordered, then looks for any receipts on that same PO and totals all of the quantities received.

If everything has been received then I want a new column to show "1". if there is still an outstanding balance I would like a "2". I have attached a mock up of what some of my data looks like and what I am trying to accomplish.


Thanks in advance. Purchase Order Sample.xlsx

That did not work. I am getting a 2 for all entries.

The first four lines in total should eqaul 24. each line is not expecting a total of 24.

In J2 through J5 should read 2. The other item should have a 1 because not all 48 have been received

My applogies. I didnt realize my error there.

The formula does work as it should when plugged into my actual data set.

Thank you so much.


However, I have a small problem and I just cant work out the logic.......