Automatically reformat Excel Data

已完成 已发布的 Mar 26, 2015 货到付款
已完成 货到付款

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.

数据处理 Excel 模板

项目ID: #7376409

关于项目

41个方案 远程项目 活跃的Mar 27, 2015

授予:

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 在3天内
(115条评论)
6.1

有41名威客正在参与此工作的竞标,均价$356/小时

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 更多

$250 USD 在4天内
(296条评论)
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 更多

$250 USD 在5天内
(301条评论)
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 在5天内
(400条评论)
7.6
zExcel

A proposal has not yet been provided

$300 USD 在3天内
(256条评论)
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 更多

$263 USD 在10天内
(450条评论)
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 在10天内
(227条评论)
7.2
zebracaro

i can do it for you quickly and exactly .

$250 USD 在5天内
(116条评论)
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 在4天内
(265条评论)
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

$250USD 在1天里
(256条评论)
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 更多

$550 USD 在5天内
(65条评论)
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 更多

$500 USD 在10天内
(124条评论)
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 更多

$388 USD 在10天内
(99条评论)
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 更多

$333 USD 在7天内
(39条评论)
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 更多

$250 USD 在4天内
(63条评论)
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 在10天内
(73条评论)
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 更多

$250 USD 在10天内
(52条评论)
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 更多

$350 USD 在10天内
(11条评论)
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 在10天内
(10条评论)
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 更多

$250 USD 在10天内
(27条评论)
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. 更多

$255 USD 在10天内
(11条评论)
3.9