Automatically reformat Excel Data

Completed Posted Mar 26, 2015 Paid on delivery
Completed Paid on delivery

We are currently getting messy Excel reports out of a volunteer management software. We need to automate a reorganization of these tables so they are usable for various grant reporting. We would need the data to be automatically reformatted from the attached "sample messy excel report" into the "desired output reports" and the "tri agency form".

Between the "sample messy excel report" and the "desired output" the reformat must take into account that the number of and types of outputs will change in the sample messy excel report.

Data Processing Excel Templates

Project ID: #7376409

About the project

41 proposals Remote project Active Mar 27, 2015

Awarded to:

gokulanand

Hello, I can get you a macro or a excel program that does this job in the next 3 days. I have few doubts regarding the re-formatting. Lets discuss on this if you are interested. Thanks

$250 USD in 3 days
(115 Reviews)
6.1

41 freelancers are bidding on average $356 for this job

bouslimi1979

Hi, I ll code a macro to work as follow : 1. First you will have to select the input file to treat. It will be a Windows window where you will just have to select the file to treat . 2 The macro will make this grouping More

$250 USD in 4 days
(296 Reviews)
7.7
seaanddream

Hi, my name is Sevinc. 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 business. I had many similar excel/vba More

$250 USD in 5 days
(301 Reviews)
7.9
P0L

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

$275 USD in 5 days
(400 Reviews)
7.6
zExcel

A proposal has not yet been provided

$300 USD in 3 days
(256 Reviews)
7.6
pandeypriya2003

Hello, We highly recommend our team for your work. They have vast experience in data entry projects like data mining, data research, typing work, magneto data entry, and product add. We are capable to provide excell More

$263 USD in 10 days
(450 Reviews)
7.3
sobujprantor

HI I would like to work with you. If you think you need a good worker then you can hire me.........Thanks

$500 USD in 10 days
(227 Reviews)
7.2
zebracaro

i can do it for you quickly and exactly .

$250 USD in 5 days
(116 Reviews)
7.1
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, forms and macros. Check my reviews. They speak for themselves. Best regards

$250 USD in 4 days
(265 Reviews)
7.0
watersev

Hi there, I have a vast exerience in Excel and VBA. I would be happy to help you on the project. Best regards. Eugene

$250 USD in 1 day
(256 Reviews)
6.5
svet63

Excel/VBA developer since 1997. The "desired output reports" is comparatively easy to produce. The "tri agency form" requires more work. Quick question, Where "Value of goods" comes from, so the pdf creation can be aut More

$550 USD in 5 days
(65 Reviews)
6.5
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 225 projects. Please look at the feedback left by my employers to know more about my work. Wai More

$500 USD in 10 days
(124 Reviews)
6.3
shikhamehta

Hello, I reviewed the three files you attached and the reformatting of 'messy' data can be done through excel macros. The system would basically work like this: 1. It will import the messy data 2. Do the transform More

$388 USD in 10 days
(99 Reviews)
6.4
vikas0903

Hi, I am working on similar project, creating financial and forecasting dashboards for top leadership. You may find project details here: https://www.freelancer.com/jobs/Excel/Dashboard-upgrades/ Would like to p More

$333 USD in 7 days
(39 Reviews)
5.6
nagybatonyi

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

$250 USD in 4 days
(63 Reviews)
5.7
renesontiongson

Hi! willing to help your project. Feel free to message me to start your project. Thank you so much and God bless.

$300 USD in 10 days
(73 Reviews)
5.5
teeares

I have completed may projects in Excel and I can do this project too. However, there are a few clarifications which are required. The activity name is available as one column in the messy sheet, but its not clear what More

$250 USD in 10 days
(52 Reviews)
5.1
dank111

Hi, My name is Dan. I am an expert in excel and all advanced functionalities. I have reviewed all the files and I can do the reformatting automatically as per the desired format. This will work with variable number More

$350 USD in 10 days
(11 Reviews)
4.6
mdkass

Hi, I saw you project needs and I'm able to do it for less then $100. I have good experience dealing with Excel data and doing Macro. Best regards.

$250 USD in 10 days
(10 Reviews)
4.3
caretrades

I have gone through all the attached files, and can provide you a well versed work, completely as per your requirements. And can also work for more or many files, if we have to. Please consider this as a serious bid, a More

$250 USD in 10 days
(27 Reviews)
4.0
vasilecaldarus

Hello, I work a lot with advanced formulas and VBA in the reporting environment for my regular job @Oracle as global reporting analyst so anything you throw at me, if described correctly should be no problem to fix. More

$255 USD in 10 days
(11 Reviews)
3.9