What Formula to use for inventory valuation?

Hello All - I am attempting to write a formula that will capture the inventory value on hand for various products. I have entered all the data in the spreadsheet and found some code online that I think will assist in the calculation. The problem is I don't know how to adapt what I found in VBA to the spreadsheet I have already started. Anyone who could help me understand what needs to be done?

In the excel file, Inventory Calc tab, cell F9 is where I would want the spreadsheet to calculate what the price per unit of inventory should be. The information will come from the Order Entry tab. Let me know what additional information will be useful.

Project Help.xlsx

Please Login or Register  to view this content.