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

We require a very basic Excel Macro (VBA) that takes a raw data file containing order details and converts it into 3 separate, formatted reports. Simple manipulation of data includes: selecting rows based on defined criteria, deleting columns, formatting columns, adding in extra rows between orders, adding in page breaks between orders, formatting each page with header and footer info that contains both static info and dynamic data from the raw file.

The macro will need to be run from a formatted page that allows each of the 3 reports to be run either independently or all at once

NOTE: There will possibly be 1 revision after the final deliverable after our team provides feedback on the report

Skills: Coding, Excel, Visual Basic

See more: convert excel table vba code, convert excel formulas vba macro, convert excel word vba, convert excel design vba design, convert excel macro google spreadsheet, convert excel access vba, upload image file using ftp excel macro vba, convert excel macro openoffice calc, convert excel macro application, convert excel spreadsheet vba, convert excel template vba, convert excel macro openoffice, convert excel 2010 vba, Convert Excel macro, convert excel html vba, convert excel macro stand alone program, import msp project data excel macro vba, excel macro vba import csv text file, convert excel sheet vba code, convert excel macro standalone

About the Employer:
( 10 reviews ) GREENSBORO, United States

Project ID: #11727398

Awarded to:


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 More

$315 USD in 3 days
(575 Reviews)

73 freelancers are bidding on average $308 for this job


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.

$250 USD in 2 days
(254 Reviews)

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 y More

$300 USD in 5 days
(251 Reviews)

Dear Project poster, I have the same kind of experience of 5 years. looking for the new [login to view URL] give me the chance to complete this project. Assuring you the 100% Quality and timeliness Thanks,

$250 USD in 3 days
(236 Reviews)

Hi: Please share the sample data along with the template of the reports. I have done several similar projects. E.g. ( Please note that ove More

$250 USD in 4 days
(155 Reviews)

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.

$250 USD in 3 days
(263 Reviews)

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 More

$315 USD in 4 days
(142 Reviews)

Hello, I'm a developer with over 5 years of experience. I work for Pratt and Whitney Canada where i'm responsible for process automation with tools like Access and Excel. I have extensive knowledge regarding C#, VBA More

$250 USD in 2 days
(28 Reviews)

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 Reporti More

$250 USD in 5 days
(149 Reviews)

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 rega More

$350 USD in 3 days
(194 Reviews)

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 pr More

$300 USD in 7 days
(139 Reviews)

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 More

$526 USD in 10 days
(21 Reviews)

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!

$250 USD in 10 days
(113 Reviews)

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. Plea More

$300 USD in 7 days
(72 Reviews)

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 More

$299 USD in 7 days
(83 Reviews)

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 Of More

$300 USD in 3 days
(98 Reviews)

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, Expe More

$250 USD in 5 days
(118 Reviews)

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. Wai More

$300 USD in 10 days
(120 Reviews)

A proposal has not yet been provided

$250 USD in 3 days
(250 Reviews)

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.

$250 USD in 7 days
(64 Reviews)

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 macr More

$250 USD in 2 days
(62 Reviews)