Find Jobs
Hire Freelancers

Create Excel Macro

$250-750 AUD

Completed
Posted over 7 years ago

$250-750 AUD

Paid on delivery
We need someone that has the skills to create a Excel Spreadsheet with Macros. The ideal situation is that when we open the spreadsheet, we click a button to import .CSV file and it will direct the user to select the .CSV file and the it will import that data and arrange it in the way I will provide. The spreadsheet is called "End of Month Closing Report" and this report will be used for internal business use as we are a serviced office provider: 1. How much we will ne invoicing clients from last month vs this month 2. Top clients by location (who has spent the most this month) 3. A summary of the spend (rent / internet / telephone / services) Ideal person is a Visual Basic expert with great communications skills. I have attached a sample of how we envision the final report once data is imported and manipulated. Cheers, Helio
Project ID: 11783193

About the project

72 proposals
Remote project
Active 8 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
$250 AUD in 2 days
4.9 (257 reviews)
7.7
7.7
72 freelancers are bidding on average $345 AUD for this job
User Avatar
Hello Sir, 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 0 failed projects and 100% completion rate 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 sample work before you consider awarding me the project. Thanks, Jay
$400 AUD in 2 days
5.0 (931 reviews)
9.4
9.4
User Avatar
Hi there - My name is Paris. I've read your brief and can see that you'd like to have a macro-enabled Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach your project by creating a draft spreadsheet and send it to you for review. I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, as well as feedback, take a look at my Freelancer Portfolio (https://www.freelancer.com/u/paris2785.html).
$300 AUD in 8 days
5.0 (668 reviews)
8.7
8.7
User Avatar
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of experience of 5 years. b) I work very hard (16+ hours a day and 7 days a week) and also very fast so... it will be done very soon than most of the other providers c) And most important part is my policy: "I will give you (to my client) life time support (as long as you keep relation with me). And fix any bugs/problem without any cost. So, don't ever worry about me” Please sir, leave a reply ASAP, as I am waiting for your kind reply
$250 AUD in 2 days
4.9 (561 reviews)
8.5
8.5
User Avatar
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
$350 AUD in 3 days
5.0 (508 reviews)
8.0
8.0
User Avatar
Hi, my name is Sevinc. I read your "Create Excel Macro" project descriptions carefully before bidding. I checked the attached template as well... I got what you need and ready to go ahead as soon as we can clarify further project details. 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 businesses. I had many similar excel tasks, including automated data extraction, aggregation and reporting, all achieved with 5/5 rating. Kindly get back to me if you wish to proceed with a top-rated and reliable partner here...pls note that I only deliver best quality at a reasonable price, and I am open for longterm partnerships, if you wish too... I bid my best for you to start business, and I am ready to prepare an excel workbook template for you to check & validate, once you give me a reply...regards.
$300 AUD in 5 days
5.0 (304 reviews)
8.2
8.2
User Avatar
Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Kindly contact me for further details. Thanks and regards Roy
$250 AUD in 3 days
5.0 (502 reviews)
7.8
7.8
User Avatar
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best regards
$350 AUD in 5 days
5.0 (336 reviews)
7.5
7.5
User Avatar
Hi, i m serious freelancer with 100% completion rate and i believe i can help you. I've done hundreds of excel projects (with both macros and formulas) and i've never had a single problem. If you are interested send me a sample CSV file so i can take a look at what exactly needs to be done. As i said i m serious freelancer and i've never took a single dollar unless my solution was perfect. Thanks, Milan
$250 AUD in 3 days
5.0 (808 reviews)
7.6
7.6
User Avatar
Hi there. Just checked your doc and project desc. I can be of help on this (csv import with a confirmation box) So that, this csv will be the raw data for your analysis file. Let me know if you are interested. Thanks..
$526 AUD in 5 days
5.0 (142 reviews)
7.2
7.2
User Avatar
i can do it for you quickly and exactly
$277 AUD in 3 days
4.9 (135 reviews)
7.2
7.2
User Avatar
Hi, I am highly skilled in Excel and VBA macros and I can develop exactly same attached report from the imported CSV's. I have delivered several similar projects before and I shall be able to finish the job in 3 days or less. Please discuss so we may proceed. Thank you, Usman
$400 AUD in 3 days
5.0 (93 reviews)
7.1
7.1
User Avatar
Greetings! I have 17+ years experience in using Excel as part of my daily work life. In the process I have implemented lot of automation similar to what you are expecting as well as dashboards for Management Reporting. In fact, over the last MONTH , I have spent at least 225 HOURS on automation in Excel. I can get your work completed to your fullest satisfaction. Looking forward to hearing a positive response from you. Thanks in advance! Have a Great Day! Srinivasan Krishnamoorthi
$250 AUD in 3 days
5.0 (258 reviews)
7.2
7.2
User Avatar
Hi: I have completed a very similar project in the recent past. https://www.freelancer.com/projects/Excel/Monthly-Report-Creation-need-program/ . Please note that over 90% of my completed projects are related to Excel and Macro. Moreover, I have 100% completion rate and 5-star feedback on projects. Please connect with me discuss your requirements in detail.
$250 AUD in 3 days
4.9 (171 reviews)
7.1
7.1
User Avatar
Hello, I am VB, VBA, C#, WPF, Java, Delphi, PHP, ASP.NET, CAD and GIS developer, I developed many desktop applications and custom tools, macros and Add-Ins. For reference see my profile. I am ready to discuss and doing the project. Regards, Eyad
$789 AUD in 15 days
5.0 (32 reviews)
7.2
7.2
User Avatar
Hello Helio, I reviewed the spreadsheet you shared and would like to inform you that I have created setups that allow users to browse and select a csv and generate the report on click of a button. If you could send a message to me, I would be able to share some samples from those and you would be able to see that these work almost exactly as you want. Can you share a csv file with some sample data please? Based on it, I would be able to determine the mapping between the input and output report and ask any queries that I may have. I am an expert in Excel and have done more than 500 projects here on freelancer. I can assure you of excellent quality work. Please send a message to me if you would like me to work on this project for you and we may discuss the next steps. Look forward to hear from you and thank you for considering my bid. Best Regards, Rishi (Automyze Consulting)
$300 AUD in 5 days
4.9 (100 reviews)
6.6
6.6
User Avatar
Hello. 30 % of employers hiring me once hired me again. I have experience in the same. I CAN do this job, and do it well!
$300 AUD in 10 days
5.0 (120 reviews)
6.6
6.6
User Avatar
Hi, I have more than 14 years of VBA/Excel exp and I am expert in this kind of work. I have completed more than 280 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
$300 AUD in 10 days
4.9 (126 reviews)
6.4
6.4
User Avatar
Hi! I would like to offer my service to create Excel spreadsheet with VBA macro as per your requirements. I have looked at the sample file where you show how you want the final result would be, and I am very confident that I can deliver that. I am a programmer for client/server, web & mobile applications. Proficient in Office VBA, Microsoft .NET + MS SQL Server, PHP + MySQL, and Android platform, I also do graphic design works, primarily UI designs and image editing. I have good attention to details in client's requirements, and once a project starts, I am 100% committed to its completion. I live in Indonesia, my timezone is GMT +7. I look forward to hearing from you. Thank you.
$250 AUD in 5 days
4.9 (106 reviews)
6.1
6.1
User Avatar
Hi, Experienced Excel VBA and VB.Net Programmer. Expertise in exchanging data between sheets, advance formulas, critical programming, developing system for management and creating reports. I have read your instructions carefully. I have excellent knowledge and experience of manipulating csv files. I will give you an open dialog box where you can select csv and it will manipulate according to requirements and create reports. I have done this job before, you can check my portfolio. Ready to start please reply soon. Thanks, Virendra
$250 AUD in 3 days
4.9 (142 reviews)
6.2
6.2
User Avatar
Hi, I can develop it using macros VBA or Visual Basic or give you a friendly to use excel with forms solution. I propose you to use an excel forms combinated with VBA inteligent macros in order to get the data from csv in a clean way and then produce your information in a excel tables spreadsheets, but additional, I will produce charts to a more convenient and comfortable way to see the results. I wish you to see my profile and read the comments from my clients, as my best reference. Please contact to chat.
$250 AUD in 10 days
4.9 (67 reviews)
6.2
6.2

About the client

Flag of AUSTRALIA
Berkeley, Australia
5.0
16
Payment method verified
Member since Jun 6, 2004

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.