Write and Excel Macro (VBA) to convert a raw data file into a usable report

Hello Sir, I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among niche bidders who have 0 failed projects and 100% completion rate since I do not bid on projects which I am not certain of. I will not disappoint you, please give me an opportunity to work with you. No milestones required. Pay me only when your job is 100% done. Also I will provide you with a working sample work before you consider awarding me the project. Thanks, Jay

Hi there - My name is Paris. I've read your brief and can see that you'd like to have a macro-enabled Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach your project by creating a draft spreadsheet and send it to you for review. I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, as well as feedback, take a look at my Freelancer Portfolio (https://www.freelancer.com/u/paris2785.html).

Hi, my name is Sevinc. I read your "Write and Excel Macro (VBA) to convert a raw data file into a usable report" project descriptions carefully before bidding. I checked the attached template as well... I got what you need and ready to go ahead as soon as we can clarify further project details. I am 5-star excel and vba coding expert here at freelancer.com. Pls check my profile and feedbacks first to have some idea about the quality of my previous businesses. I had many similar excel tasks, including automated data extraction, aggregation and reporting, all achieved with 5/5 rating. Kindly get back to me if you wish to proceed with a top-rated and reliable partner here...pls note that I only deliver best quality at a reasonable price, and I am open for longterm partnerships, if you wish too... I bid my best for you to start business, and I am ready to prepare an excel workbook template for you to check & validate, once you give me a reply...regards.

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

A proposal has not yet been provided

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best regards

Hi, I'll be happy to help you with this project . I have plenty of experience in all aspects of Microsoft Excel, especially in developing custom functions and macros and can complete the job rather quick;y.

Hello, I am VB, VBA, C#, WPF, Java, Delphi, PHP, ASP.NET, CAD and GIS developer, I developed many desktop applications and custom tools, macros and Add-Ins. For reference see my profile. I am ready to discuss and doing the project. Regards, Eyad

Hi there. Your raw data file is csv? Or you export it from an ERP, CRM or similar software and put into excel? We can write the macro to create the necessary reporting output. Please check my dashboard examples from my profile page. I will be happy to work on this project. Just contact me and lets discuss more about your job. Thanks..

Greetings! I have 17+ years experience in using Excel as part of my daily work life. In the process I have implemented lot of automation similar to what you are expecting as well as dashboards for Management Reporting. In fact, over the last MONTH , I have spent at least 225 HOURS on automation in Excel. Only yesterday I completed a similar project - Amazon Settlement Report. I can get your work completed to your fullest satisfaction. Looking forward to hearing a positive response from you. Thanks in advance! Have a Great Weekend! Srinivasan Krishnamoorthi

Hi, I have read the project and understand your requirement. I am a highly trained on Data Entry ,Data Analysis, Statistical Analysis, Research, Web search, Web scraping, Product Add, Any Type Of Ecommerce Cart, Expert with great knowledge of Word, Excel and PDF. Apart from this type of job I have experience in Internet research, Virtual Assistant, Business Data analysis with excel VBA formula generation etc. Kind regards, Fatima

Hi: Please share the sample data along with the template of the reports. I have done several similar projects. E.g. (https://www.freelancer.com/projects/Excel/Monthly-Report-Creation-need-program/) Please note that over 90% of my completed projects are related to Excel and Macro. Moreover, I have 100% completion rate and 5-star feedback on projects. Please connect with me discuss your requirements in detail.

Hi there. My name is Daniel and I would be glad to help you out with this project. I would like to take a detailed look to the reports you want to build, in order to let you know the best approach to accomplish them. I would recommend doing a basic dashboard in Excel that will allow you to trigger either ones of the reports, or all at once. Hope to hear back from you soon. Thanks!

Hello. 35 % of employers hiring me once hired me again. I have experience in the same. I CAN do this job, and do it well!

Hello, My name is Chris and, as you can see from my profile, I have 16+ years experience working with Excel/VBA and 13 years teaching them both (all levels). I can certainly do excellent work with your project. Please contact me to further discuss the details. Looking forward to hear from you, Kind regards, Chris (chriskerpini)

Hi, I have more than 14 years of excel/vba exp and I am expert in this kind of work. I have completed more than 280 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.

VB, VB.NET, ASP.NET, MVC, XML, MSSQL, HTML & CSS3 programmer. I have experience about 20 years in programming complex database application as well as Windows Desktop and Server/Client application. you will get yearly service and support as well as update of this software to avail new version from me. I am professional to provide corporate custom complex software which is not available in the recent market. So you may turn your desired application dream to real. Long term support.

Hello, I am Excel and VBA expert. Can I see sample file? Please note that I have 100% completion rate and 5-star feedback on 50 projects.

Hi! I would like to offer my service to write VBA code for Excel macro to convert raw data file into 3 separate, formatted reports. I am a programmer for client/server, web & mobile applications. Proficient in Office VBA, Microsoft .NET + MS SQL Server, PHP + MySQL, and Android platform, I also do graphic design works, primarily UI designs and image editing. I have good attention to details in client's requirements, and once a project starts, I am 100% committed to its completion. I live in Indonesia, my timezone is GMT +7. I look forward to hearing from you. Thank you.

Hi, I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. I plan to complete the project via writing an Excel macro contained in a separate XLSM file. This approach makes further use of the macro very convenient by offering a Control sheet containing cells populated by the usual Open file and/or select folder dialogs to identify the current input and output files (or the folders containing them, as required by the job) and hosting command buttons and other controls if necessary. In my approach you'll have opportunity to consult details with me, to test pilot solutions if necessary in order to achieve an optimal final solution. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees. I can start working on the project immediately and complete the job within one, maybe two days. If you send me a sample file and a job specification, I'm ready to create a free draft pilot for you. Regards

Can get the raw data of the order details and convert them per the format in Excel using automation and macros. - Examples of works similar to this - Data consolidation - Financial summary statement for a HKG dealer, Calculations based on criteria - Canadian tax calculations, Heating design for Canadian firm inprogress. - Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs. - Please review my portfolio on recent projects completed. - Have done exam results grading by finding keywords, Canadian Province tax calculations based on province parameters, Heating design based on current/voltage restrictions, merger of rows and columns of data based on key values My Skills: - I have good skills in Excel automation and used extensively the macros/VBA to automate: - 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 - Outlook automation - Performing different actions other that using the existing rules, updating calendars based on logic. - MS Access - Expert in designing table, user input forms and also reporting from data. - Excel to MS access data porting and conversion and designing new system for use.