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,500.00 - 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.


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

Evner: Dataindførsel, Databehandling, Excel, Visual Basic

Se mere: work notes freelancer, reporting a freelancer, freelancer raw process, freelancer for excel macro, freelancer data entry client, edit entry freelancer, does freelancer work, auto populate data in excel, pivot tables, excel templates, excel PIVOT, Do some excel work 2, do some excel work -- 2, data entry from 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

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

Projekt ID: #6032851

Tildelt til:


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
(259 bedømmelser)

28 freelancere byder i gennemsnit $355 på dette job


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 Flere

$555 USD in 10 dage
(559 bedømmelser)

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 Flere

$250 USD in 2 dage
(188 bedømmelser)

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. Flere

$500 USD in 5 dage
(85 bedømmelser)

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 Flere

$250 USD in 4 dage
(164 bedømmelser)

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

$250 USD in 10 dage
(186 bedømmelser)

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 Flere

$488 USD in 15 dage
(180 bedømmelser)

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 Flere

$250 USD in 3 dage
(72 bedømmelser)

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 Flere

$250 USD in 5 dage
(62 bedømmelser)

Sir, I am well versed in this kind of jobs and can do your project as per requirement. Refer my online work portfolio at [login to view URL] Looking for further discussions in this matter. with than Flere

$263 USD in 7 dage
(98 bedømmelser)

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
(10 bedømmelser)

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 Flere

$315 USD in 10 dage
(79 bedømmelser)

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

$444 USD in 10 dage
(38 bedømmelser)

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 Flere

$421 USD in 5 dage
(10 bedømmelser)

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 Flere

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

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
(21 bedømmelser)

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, Flere

$250 USD in 6 dage
(17 bedømmelser)

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 Flere

$333 USD in 10 dage
(18 bedømmelser)

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
(7 bedømmelser)

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 Flere

$250 USD in 2 dage
(3 bedømmelser)

Skills and Experience: • Web Site Development • Desktop Database Development • Facebook Custom Tab Development • ASP.NET, VB.NET, CSS and C# • Visual Basic 6.0, Microsoft Access, and SQL Server. • VBA (Excel, Acc Flere

$555 USD in 10 dage
(5 bedømmelser)