Excel Macro to calculate selling value by FIFO method
Create an excel Macro to analyze transactions and calculate the selling value of each asset using the FIFO method.
1. “History” Worksheet –All transactions recorded by date. The macro should calculate the sell values of the asset according to FIFO method.
2. “Inventory” Worksheet - Shows the remaining amount of each asset.
See the excel example.
It should be able to handle big amount of trades and assets.
Được trao cho:
I have a large and successful practical experience of processing and analyzing data in Excel, including using the VBA. Your task is clear to me and I am ready to execute the project for 30 USD for 1 day.
17 freelancer đang chào giá trung bình $35 cho công việc này
I can work on excel and do my job following the deadline. Relevant Skills and Experience I know how fifo [login to view URL] since I have been in manufacturing industry for 3 years. I can work on it for you