Excel Macro to calculate selling value by FIFO method

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.

"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 (MBA) Graduate with major in Finance and MARKETING along with 5 years of experience in different analytical roles. Currently I am working for a MNC as an B2B Analyst Manager.I believe I can do a fantastic work for you if you provide me the opportunity. "

Hello, I am experienced excel profesional. I can help you with this. Looking to hearing from you. regards

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 forward to discuss in chat and work on the project.

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, Power BI & Microstrategy Dashboards, MS & Google Office Suites, WordPress, Social Media Marketing and Touch Typing 60wpm Skills.

- 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 calculate "As of Day" Status and show it up in the Inventory list the quantity available and the rate using FIFO method. My Skills: - Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs. - Extensively the macros/VBA to automate: - Data camparision using formulas, lookups and summaries., - Data validation in a particular, Data consolidation into sheets, comparing, plugging in default values for few cells - Data camparision using formulas, lookups and bringing up summaries., - Mathematical functions, scientific calculations, index, array, formula arrays which are advanced concepts - Have used them. - With summary data plotting graphs, bringing pivot tables - Pl. review my portfolio on projects done - https://www.freelancer.com/u/satishtl

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 handled about 300000 rows in excecl. If you can provide more details about the work then will be able to provide a more accurate pricing and timelines. Thanks Regards Vaidy

This work will best for me because i am experienced in this field our experience will great ever. I am a Programmer & Graphics Designer

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 have done this in past. Can hel you witb this if you share the details with me