I have a spreadsheet for which I am trying to calculate the cost of inventory on hand at any given time. This will use the first in first out methodology of inventory, if anyone cares! I have found VBA code online that I believe will work but I do not know how to adapt this code to my spreadsheet. Can anyone please give me an idea or help me put this code in the spreadsheet?
Below I have captured the VBA code I am trying to utilize. 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.
Option Explicit
Bookmarks