FIFO valuation for Mutual fund sale transactions

We need some code in VBA to calculate the FIFO cost of Mutual fund sale transactions. There are various transactions in excel format. Please apply only if you can understand FIFO valuation principles for stock and mutual fund transactions. If you are good in VBA/excel you can apply if you wish to learn how to do FIFO valuation.