I gang

Do some Excel Work

We are looking for a Freelancer to write an Excel Macro to assist with our client reporting. So, to take our raw data, prepare it and auto populate our reporting templates.

Here is the current process:

1. Multiple reports are collected (all with slightly different layouts), and all in CSV format.

2. We edit the data in the reports to ensure Excel recognizes all figures. For example some cost data is shown as $4,[url removed, login to view] - excel does not recognize this as a number, so we have to remove the comma.

3. Data is then put into pivot tables.

4. Data from pivot tables is then manually copied into a reporting template.

Notes:

- Data sets may vary from report to report, so the macro must be able to adjust dynamically.

- Upon acceptance of the project, we can send through examples of each step of the work.

Færdigheder: Dataindførsel, Databehandling, Excel, Visual Basic

Se mere: work notes freelancer, reporting freelancer, freelancer raw process, freelancer data entry client, edit entry freelancer, auto populate data excel, pivot tables, excel templates, excel pivot, data entry raw, macro pivot, edit macro, excel macro csv, excel 2014 macro, excel report macro, raw data csv, cost excel template, csv raw, excel raw data work, send data dynamically, reporting template, pivot report, macro report, edit macro excel, excel edit

Om arbejdsgiveren:
( 0 bedømmelser ) Cape Town, South Africa

Projekt-ID: #6032851

Tildelt til:

zExcel

Hi, I'll be happy to help you with this project. I will start as soon as you have awarded me the project Please feel free to message me if you need to discuss any questions

$250 USD in 2 dage
(91 bedømmelser)
6.3

29 freelancere byder i gennemsnit $351 for dette job

maverick44000

Hi there. I am Usman and I have been working with VBA macros for some time. I would be glad to help you with your reporting sheet. I am experienced in advanced Excel skills and have done a few similar projects before. Mere

$500 USD in 5 dage
(49 bedømmelser)
6.2
sonarkaushik

Sir, I am well versed in this kind of jobs and can do your project as per requirement. Refer my online work portfolio at http://bit.ly/Lta2EN Looking for further discussions in this matter. with than Mere

$263 USD in 7 dage
(85 bedømmelser)
6.1
best4best

I am an Excel expert. Please share the files with detailed requirements for accurate work. Thanks.

$250 USD in 10 dage
(134 bedømmelser)
5.9
dpune

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

$488 USD in 15 dage
(93 bedømmelser)
5.8
nagybatonyi

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 u Mere

$250 USD in 5 dage
(53 bedømmelser)
5.7
jaylancer43

Hello - 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 n Mere

$555 USD in 10 dage
(69 bedømmelser)
5.6
ethicalboy

Hello ready to start asap to deliver you, If you can give me your notes and conditions, I can deliver it to you fast, also about me: I am m.s of systems engineering and b.s of industrial engineering, and excel and vba Mere

$315 USD in 10 dage
(57 bedømmelser)
5.1
chriskerpini

Hello, Excel and VBA provide all the necessary tools to read the data in the exact format you want, so this is not a problem. All the steps you are describing can be fully automated via VBA, even the data transferri Mere

$250 USD in 3 dage
(27 bedømmelser)
4.9
abdellatif81

Hello, I am IT engineer with European diploma since 2005 Certified as Technical specialist in Microsoft SQL Server databases BI, i have more than 8 years in IT projects with 5 years working around databases and BI Mere

$421 USD in 5 dage
(8 bedømmelser)
4.9
adim

Hello there, I'm a software engineer with more than 15 years experience in Excel, Access, VBA, VB6, .NET, SQL. I'm waiting for detailed project description. I am Top 1% in Excel VBA on Freelancer and lot of exper Mere

$250 USD in 3 dage
(17 bedømmelser)
4.8
MuradMurad

Hi, I have lots of experience with Excel automation using VBA macros and can help you in short terms with this project, you can check my latest project on this. Can you send me sample data to show you a demo?

$555 USD in 10 dage
(6 bedømmelser)
4.7
aarifakhtar

Hi: I have the project description. However, it would be great if you could share a sample sheet. This will allow me to provide you an actual estimate of cost and effort. I would be happy to discuss your requirement in Mere

$250 USD in 4 dage
(18 bedømmelser)
4.7
abdolah2014

HI I am an excel-vba expert and I can help U with your project pm me ...............................................................................................

$444 USD in 10 dage
(17 bedømmelser)
4.4
excelsolution

Hi, I have very strong skills in Excel, VBA/Macro and automation. I have gone through your requirements and I can clearly visualize what needs to be delivered and the level of automation that can be built in. Pl Mere

$333 USD in 10 dage
(28 bedømmelser)
4.2
elqueabandona

Hello, my name is Cristian, I have a degree in Business and I work with excel every day. I have much experience with spredsheets, complex formulas and macros. Check mi excel reviews. I can solve this project for you. C Mere

$250 USD in 2 dage
(13 bedømmelser)
4.1
denissilanov

Hi! I have 8 years experience in programming and know Excel VBA well. I can make this work for you. Everything will be done according to your requirements. I'm ready to discuss details. Denis.

$600 USD in 10 dage
(6 bedømmelser)
3.8
Aan12

I can do this type of job quickly and at minimum price. All I need is the files, the examples and the specification. I have Excel and VBA macros experience (you can check my profile). If you are interested in my bid, Mere

$250 USD in 6 dage
(14 bedømmelser)
3.8
sachit89

In my current job, I have made a very similar tool. We get CSV files from our Business Information Warehousing portal. These are sales, closing stock and other parameters reports (each one on different reports). The Mere

$250 USD in 2 dage
(2 bedømmelser)
2.9
lxqcad

Send me the data files and the steps you undertake to arrive at the output. I can start work right away and deliver a sample even before you accept my bid. That way you can be sure of my capability to do the task.

$250 USD in 3 dage
(5 bedømmelser)
2.6
ssviatlana

Hello! I interested in this project. I worked as an analyst in several retail companies for over 10 years and I have extensive experience in software development and automation using Excel, including VBA Coding, Macro Mere

$250 USD in 3 dage
(1 bedømmelse)
1.6