Checking when inventory is available for sales order

[CoffeeBean99]

Hi,
I'm looking for a way to indicate that the entire sales order in Column A and the required qty for this order in Column C can be fulfilled with the inventory available from Column C. The criteria is that the entire sales order (all cells with same sales order value) must have qty available from column C for that specific column. I'm falling flat on finding a solution to this, any help would be appreciated!

 

[danzon]

How about if you add a helper column to check each sku... and then you just use a pivot table that tells you by ORDER number if it is ready

something like this : in the example I give we see that order #2 is not ready to go ( sku B does not have enough on hand )

 

[CoffeeBean99]

How about if you add a helper column to check each sku... and then you just use a pivot table that tells you by ORDER number if it is ready

something like this : in the example I give we see that order #2 is not ready to go ( sku B does not have enough on hand )

Ah! I knew it would be something simple - thank you!