Help please! I have an inventory issue I need to work on. I have a production schedule where my production team adds line items for the PO they are supposed to work on. Each Line item may have the same item number, and could have the same quantity. I am using data shuttle to pull in my available inventory. From there I am doing a vlookup for inventory availabe based on the item number. When a line item is added I want it to lookp item, check the available inventory mark the status from pending or inventory issue to ready for production if there is enough inventory. (right now it is a manual check and I want to try and automate this.) Then subtract the quantity available on inventory available and move to the next line item and etc. Do I need a new sheet that copies the line items, checks the inventory and then updates my production schedule? I am not sure where to go from here.
Production Schedule
Inventory available
Inventory check - not sure if this is necessary