Find Jobs
Hire Freelancers

Do some Excel Work

$250-750 USD

Completed
Posted almost 10 years ago

$250-750 USD

Paid on delivery
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. 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.
Project ID: 6032851

About the project

28 proposals
Remote project
Active 10 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
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 days
4.9 (259 reviews)
7.7
7.7
28 freelancers are bidding on average $355 USD for this job
User Avatar
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 niche bidders who have zero failed projects since I do not bid on projects which I am not certain of. I will not disappoint you, please give me an opportunity to work with you. No milestones required. Pay me only when your job is 100% done. Also I will provide you with a working version of file before you award me the project. Thanks, Jay
$555 USD in 10 days
5.0 (559 reviews)
8.2
8.2
User Avatar
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. Kindly discuss and share the existing sheet so I may have a look. Regards. Usman.
$500 USD in 5 days
5.0 (85 reviews)
6.9
6.9
User Avatar
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. Chat with me, best regards.
$250 USD in 2 days
5.0 (188 reviews)
6.7
6.7
User Avatar
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 more detail. Please connect with me to discuss more.
$250 USD in 4 days
4.9 (164 reviews)
7.0
7.0
User Avatar
I am an Excel expert. Please share the files with detailed requirements for accurate work. Thanks.
$250 USD in 10 days
5.0 (186 reviews)
6.5
6.5
User Avatar
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 response. Thanks.
$488 USD in 15 days
4.9 (180 reviews)
6.5
6.5
User Avatar
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 transferring from the pivots to the reporting template, and of course this can be developed to handle the data dynamically, independently of the data set derived each time. A few words about me: I'm developing VBA programs for more than 15 years and I'm a trainer of Excel and VBA for 12+ years. As you can guess, I have created a plethora of VBA programs of any kind, reports, dashboards, pivots, ... for both training purposes and business. Looking forward to hear from you, Kind regards, Chriskerpini
$250 USD in 3 days
4.9 (72 reviews)
6.6
6.6
User Avatar
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 usual Open file and/or select folder dialogs to identify the current input and output files and hosting command buttons and other controls if necessary. In my approach you'll have opportunity to consult details with me, to test pilot solutions if necessary in order to achieve an optimal final solution. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees. When considering the delivery time in my bid please take into account that job specification is not yet completed, and the design phase of a project comes out at a very significant percentage of the total completion time! Regards
$250 USD in 5 days
4.9 (62 reviews)
5.7
5.7
User Avatar
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 expert. I have done similar projects and I am confident about my profession, I also accept revisions and removing errors and minor changes in future for free, whenever you are ready lets go. I have good command of English that I think can be useful for this project. I have a base of statistics, mathematics, accounting, cost calculating, project scheduling and project management and finance that helps in this project.
$315 USD in 10 days
4.8 (79 reviews)
5.4
5.4
User Avatar
HI I am an excel-vba expert and I can help U with your project pm me ...............................................................................................
$444 USD in 10 days
5.0 (38 reviews)
5.3
5.3
User Avatar
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 days
4.9 (10 reviews)
5.2
5.2
User Avatar
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 development. My last job was senior BI consultant within Accenture ,for more than 4 years .I worked for several database projects and advanced SQL development on behalf of European Customers (Carrefour, LOREAL,Eurovia ..). I have strong skills in Excel pivot tables and Business Intelligence to develop all types of requirements related ,and given my experience, I am persuaded to give you High quality of work delivery withing budget and time Best regards,
$421 USD in 5 days
5.0 (10 reviews)
5.0
5.0
User Avatar
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 days
4.8 (21 reviews)
4.9
4.9
User Avatar
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 experience in this field. Have done many similar projects in the past, you can see that in my profile. Regards, Adrian
$250 USD in 3 days
4.9 (17 reviews)
4.8
4.8
User Avatar
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 days
5.0 (7 reviews)
3.9
3.9
User Avatar
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, just send me a message so we can discuss the details of this proyect. Thanks!
$250 USD in 6 days
4.8 (17 reviews)
4.1
4.1
User Avatar
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. Please send me more information and sample of the csv reports you need to be consolidated.. A brief write-up on the requirements would really help me in preparing a demo. I can point you to some of the similar project work and customer reviews that can help you to evaluate me. Request you to please provide more info Thanks & Regards Excel Solution,
$333 USD in 10 days
4.7 (18 reviews)
4.1
4.1
User Avatar
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 macros that I have made automatically reads these reports, performs analysis (e.g. % acheived against target) and populates a set template which is then mailed across to the entire workforce. Your project is exactly similar and I'll be able to finish it off quickly.
$250 USD in 2 days
5.0 (3 reviews)
3.5
3.5
User Avatar
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, Macros, PivotTables, Charts/Graphs, Formulas, and Analysis. Please contact me to discuss further details.
$250 USD in 3 days
5.0 (1 review)
1.6
1.6
User Avatar
Good day, I have plenty experience with Excel and macros and I would like to win this project. I have some questions: 1. The datasets may change, so the macro needs to be flexible. What is going to be the reference to ensure the right fields will be populated with the right items? Do they have consistent titles, for example? 2. Or do you have in mind, to be able to map the specific dataset when you are loading the data. Regards, MariaLR
$555 USD in 10 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of SOUTH AFRICA
Cape Town, South Africa
0.0
0
Payment method verified
Member since Jun 5, 2014

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.