Subtract list of items from Inventory



I have a Inventory Sheet with list of items and also the quantity of each item. I also have products that use various items from the Inventory list, for example: Product #1 = 2 screws, 1 sign, and 2 hooks. And the way I have set it up now, every time when I sell Product #1 I have to manually search up each item and subtract it. Is there any way that when I insert "Product #1 sold" in a row, that it would automatically search the items in the inventory and subtract them?

Thanks in advance!

Best Answer