In Progress

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 word vba, convert excel access vba, 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 standalone, convert excel macro perl, convert excel app vba, convert excel macro access, report output convert excel, convert excel sheet vba

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

Project ID: #11727398

Awarded to:

jaylancer43

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
(359 Reviews)
7.6

76 freelancers are bidding on average $308 for this job

zExcel

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
(248 Reviews)
7.6
seaanddream

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
(180 Reviews)
7.0
someka

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
(105 Reviews)
6.7
esalem

Hello, I am VB, VBA, C#, WPF, Java, Delphi, PHP, [url removed, login to view], 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
(17 Reviews)
6.4
aarifakhtar

Hi: Please share the sample data along with the template of the reports. I have done several similar projects. E.g. ([url removed, login to view]) Please note that ove More

$250 USD in 4 days
(122 Reviews)
6.6
elqueabandona

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
(139 Reviews)
6.5
wsh2

Greetings from Easton PA, USA.. {smile} Highly experienced (25+ years) MsEXCEL Business System, Programming, and Database expert with Guru / Mentor level technical credentials at [url removed, login to view] and [url removed, login to view] More

$373 USD in 10 days
(42 Reviews)
6.1
dpune

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
(99 Reviews)
6.2
DanielVizcaya91

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
(53 Reviews)
6.2
chriskerpini

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
(55 Reviews)
6.2
P0L

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
(104 Reviews)
6.2
lukaszoz

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
(24 Reviews)
5.7
paris2785

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
(95 Reviews)
6.1
bossumd

Hello! I have a great Experience in Excel and Visual Basic for Excel, also I've already completed a lot of similar projects, so I'll be happy to help you with your project. I'm able to start right now!

$300 USD in 3 days
(97 Reviews)
5.6
gayuh

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
(64 Reviews)
5.6
nagybatonyi

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
(57 Reviews)
5.7
macroPOL

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
(51 Reviews)
5.3
katilinas

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
(69 Reviews)
5.4
TonmoyRoy111

A proposal has not yet been provided

$250 USD in 3 days
(123 Reviews)
5.6
schoudhary1553

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

$250 USD in 3 days
(51 Reviews)
5.0