Find Jobs
Hire Freelancers

Creating a macro in Excel

$10-30 CAD

In Progress
Posted almost 9 years ago

$10-30 CAD

Paid on delivery
I need a macro created for extracting, sorting and formatting data. There is a file attached for steps that I take manually to extract the information. I need the same steps created in a macro. Also attached is a raw data that you will be using to create the macro. This raw data is very simple, but the macro needs to be able to work with small and large amount of data. You will only get paid if the macro works. We will test the macro with various types of data and if it works then the payment will be issued.
Project ID: 8267544

About the project

26 proposals
Remote project
Active 9 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
26 freelancers are bidding on average $52 CAD for this job
User Avatar
Hi sir, I am scraping expert, I have did too many similar projects, please check my feedback then you will know. Can you tell me more details? then I will provide demo data for you. Thanks, Kimi
$120 CAD in 3 days
5.0 (224 reviews)
7.4
7.4
User Avatar
A proposal has not yet been provided
$100 CAD in 1 day
4.9 (256 reviews)
7.6
7.6
User Avatar
I can do it for you quickly and exactly. . . .
$111 CAD in 3 days
4.9 (115 reviews)
7.0
7.0
User Avatar
A proposal has not yet been provided
$30 CAD in 2 days
4.9 (366 reviews)
7.0
7.0
User Avatar
A proposal has not yet been provided
$29 CAD in 2 days
4.8 (221 reviews)
7.1
7.1
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
$122 CAD in 3 days
4.9 (241 reviews)
7.0
7.0
User Avatar
I think I am a good fit for this job because I have all the qualities that you are looking for. Experience is the golden factor in this project where you find in me at least 3+ years of working experiences over all the factors in your project.
$20 CAD in 1 day
5.0 (84 reviews)
6.3
6.3
User Avatar
Sir, I am well versed in this kind of jobs and can do your project as per requirement. I have over 8 years of experiences and will deliver flawless work. I am very much able to work on this. ***I am ready to start Waiting for further discussion.. with thanks and regards
$24 CAD in 2 days
4.7 (58 reviews)
5.8
5.8
User Avatar
I am willing to discuss further about the project details and deliver the same to your needs and specifications.
$44 CAD in 1 day
4.8 (25 reviews)
5.5
5.5
User Avatar
I have questions to ask as your document needs more explanation. Other than that, it seems easy. But if possible, I want to see the original data and work with it. Regards
$55 CAD in 1 day
5.0 (21 reviews)
4.4
4.4
User Avatar
Sir/Madam, Good day! I'm a degree holder and I'm an expert in excel/spreadsheet with experienced in vb in excel, vlookup, automated formulas, macro, HD charts and figures, etc. I'm also a virtual assistant for 3 years doing excel jobs. You will find me to be motivated and hardworking individual. Please contact me now. Thank you.
$25 CAD in 1 day
4.9 (2 reviews)
3.3
3.3
User Avatar
Hi, Please send a message so we can discuss your requirements. Also, I already have a file which does a similar job. I can send the sample file to you. Thanks, Chris
$45 CAD in 1 day
5.0 (9 reviews)
3.3
3.3
User Avatar
A proposal has not yet been provided
$25 CAD in 1 day
4.9 (6 reviews)
2.9
2.9
User Avatar
Hi! I checked your files, all is possible. I could do it in 1-2 days, but few days are necessary to check and to make adjustments if needed.
$30 CAD in 4 days
5.0 (1 review)
0.8
0.8
User Avatar
i'm working in data processing corp. as data editor, we frequently create macro to automate task, i'm an IT grad, knows VBA and visual basic
$77 CAD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$25 CAD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I have done simular projects in my workplace. I optimized my own monthly reports, and I now do them for 15 minutes, instead of the 6 hours they took before automatization. Depending on the complexity of the macro, I can deliver much faster than 2 days. I am Excel proficient user. I use macros for more than 2 years. I have successfully completed projects, saving 5-6 manhours per run (on a report, executed every day). I do formatting macros, work with pivots, tables, file operations (splitting 1 sheet of data for different clients to separate files for all the clients, named with specific naming conventions), Outlook (meeting requests based on excel source, mailing distribution based on excel source). My most complex project is generating metrics report for 60-70 accounts, using different tools with different tool logic (hence metrics logic for each), which serves the managerial team of my unit with all information they need on the monthly performance. Manually (with standart excel features, including formulas and pivots), reporting all metrics would take more than a manmonth, due to the poorly structured data in the tools, we now do it in a day. I provide post-implementation support of the macros, if such is needed
$35 CAD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I am an advanced excel user and I have the skill set to complete this task. In my previous role I created a number of macros for sorting and formatting large amounts of data so that it can presented in a more manageable way. Before getting started I would like to discuss the outcome that you are trying to achieve from the process that you have laid out. I understand that these are the steps you take when doing the process manually but sometimes there are better/faster/easier ways of achieving the same result with a macto. I see the final picture shows a table that is colour coded based on the results, but some understanding of what it is would greatly help. I believe I am an excellent candidate for this job and I am a native English speaker (originally from New Zealand and recently moved to Poland). I believe this is key to understanding the requirements of the job and ensuring that I provide you with what you need. Kind regards, Sam
$160 CAD in 6 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have worked extensively with Excel, VBA, Financial Modelling and Dashboards. I enjoy creating files that are easy to use and re-use, give meaningful answers and assist with accurate decision making for business. I would be available to discuss this further if required.
$35 CAD in 4 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$50 CAD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of CANADA
Burlington, Canada
5.0
55
Payment method verified
Member since Aug 26, 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.