I have a workbook with 3 tabs – Inventory Sheet, Mat Log, Cost Tracking.  

The cost tracking sheet had the original inventory amount that we need to start with (Column J).

On the Mat Log sheet, when an item is removed or added to inventory, the person will enter the date in column A, the Mat. Code in Column B – and that will populate the name in Column C.  Column F is the amount they are taking out (negative number) or putting into inventory (positive number).  Here is where the “I need help” comes in.  On the inventory sheet, I need the quantity associated the product code to always be updated based on what happens on the Mat Log sheet. 

​I have a workbook with 3 tabs – Inventory Sheet, Mat Log, Cost Tracking.  The cost tracking sheet had the original inventory amount that we need to start with (Column J).On the Mat Log sheet, when an item is removed or added to inventory, the person will enter the date in column A, the Mat. Code in Column B – and that will populate the name in Column C.  Column F is the amount they are taking out (negative number) or putting into inventory (positive number).  Here is where the “I need help” comes in.  On the inventory sheet, I need the quantity associated the product code to always be updated based on what happens on the Mat Log sheet.   Read More

​