Hi,
I need some help to modify this code I got from this link:
http://www.mrexcel.com/forum/excel-questions/167756-inventory-fifo-lifo-average-cost.html
I only needed the average cost section, so I extracted that only. However, I want to modify the code such that I could calculate the average cost based on the inventory item in order of the date.
I need some help to modify this code I got from this link:
http://www.mrexcel.com/forum/excel-questions/167756-inventory-fifo-lifo-average-cost.html
I only needed the average cost section, so I extracted that only. However, I want to modify the code such that I could calculate the average cost based on the inventory item in order of the date.
Quantity | Cost |