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.
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.
Bu iş için 18 freelancer ortalamada $35 teklif veriyor
"I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work. I am a Business Daha Fazla
- Went through the FIFO worksheet and the History and INventory tabs. - Based on the daily transactions purchase or Sales of a particular SKU the costing and selling prices and the items sold on ongoing basis can calc Daha Fazla
HI, I have excellent experience in Excel and Access and other Microsoft related. I have written complex macros like creating a BoM for an ERP, creating P/L, Cashflow statements from a database. In one of the macro i Daha Fazla
Hello, I am experienced excel profesional. I can help you with this. Looking to hearing from you. regards
Hi I would like to bid for this project. I posses Data Analytics, Research, Accountancy, Administration, Banking, Financial/Business Analysis & Reporting and Content Writing experience with Advance MS Excel Dashboards, Daha Fazla
I am proficient with excel macro/VBA development, I can write the code to read data from sheet 'History' and generate report as per specified in sheet 'Inventory', if you are interested feel free to message me, looking Daha Fazla
Hi Nice to meet you. I have rich experiences with Excel VBA and I'd completed a lot of projects. Your project seems to be simple, so I think i can do it in short time. You might visit my profile to confirm my sk Daha Fazla
Hello, Thank you very much for this FIFO method expart Project. I read through the job details extremely carefully and understand your required, for this I am absolutely sure that I can do the project very well. I can Daha Fazla
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
please send the file, I can do the project with excel visual basic. Even if you want to automate printing out, it will be done within a day.
I can do your project efficiently and in time ...... I will be grateful if you see my profile... thank you
This work will best for me because i am experienced in this field our experience will great ever. I am a Programmer & Graphics Designer
I have done this in past. Can hel you witb this if you share the details with me