Find Jobs
Hire Freelancers

Create sample macro for excel -- 2

$10-30 USD

Closed
Posted almost 8 years ago

$10-30 USD

Paid on delivery
It was created excel macro file containing the base spreadsheet (UID_RAW) and report (BULK_SITE). Macro works perfectly but slow! It needs to be accelerated. Before i choose right bidder for this job i would like to see your solution (at least test version).
Project ID: 11114117

About the project

19 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
19 freelancers are bidding on average $27 USD for this job
User Avatar
Hi, Yesterday I prepared the same excel file as a test and the guy canceled the project and deleted his account. Anyway, I will be glad to give ou this ready file but be sure that you got a payment. Because I worked on this "test" around 12 houses, I want the money in advance.
$35 USD in 1 day
4.9 (70 reviews)
6.8
6.8
User Avatar
Hi, I was working in your improvement and I got a processing time reduction from 6.53 ticks to 3.40 ticks. The main code line that makes the macro last is the .Find command. In my improvement, there is one .Find command remaining, so, I can make it faster. Let me know your thoughts.
$30 USD in 0 day
4.9 (41 reviews)
6.0
6.0
User Avatar
Hi, i can help you with this as i have a very good experience in VBA, please share the sheet with me and let me do it for you :)
$25 USD in 0 day
5.0 (30 reviews)
5.4
5.4
User Avatar
Hello, I have been working as freelancer since last ~ 3 years,prior to this was working with a MNC as an Sr. Software Professional. The project is Product based development and integration of the product with various already existing Products and processes.. Below are some key areas of my skills: -- VBA and Excel,Word,Office Applications -- Expert on C# using .NET framework using Visual Studio 2012 and 2013 -- Expert in ASP.NET,MVC -- Expert in VB.NET using VS2012/VS2013 -- WPF and Windows Forms Application I have experience in all the above areas and during my project work I have completed all of the above tasks. As a Freelancer also I have worked in few of the above areas where I got a chance and delivered the best. Delivering best & Customer satisfaction is the key for any individual and I always worked keeping these things during project execution. Would be looking forward to work on this opportunity and will ensure to deliver best. Regards, Abhinov
$25 USD in 1 day
4.9 (58 reviews)
5.5
5.5
User Avatar
A proposal has not yet been provided
$50 USD in 3 days
4.9 (22 reviews)
4.1
4.1
User Avatar
I have already completed the macro, I have the working vba/macro code for the said task please initiate a conversation from your end to discuss delivery of the code and further Hi, I will complete this task in few minutes/hours We can chat before you award me this project You can pay me after I have delivered you the working file Looking forward to hear from you Thank you
$30 USD in 1 day
5.0 (6 reviews)
2.6
2.6
User Avatar
Hello, I will try to accelerate your old macro, but first I have to get file to check if it is possible. Let me know if you want me to this job. Kind regards, Nosek
$18 USD in 3 days
5.0 (7 reviews)
2.3
2.3
User Avatar
Hello I am experienced in MS excel and can solve your problem quickly at reasonable price. Waiting for your reply.
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi 1000 uids in 2 seconds using native functions and a almost zero of macro if you desire (copy and "paste special" only) thank you
$35 USD in 0 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I have an engineering background, and I have worked in an investment bank where I have automated various processes using Excel and Macros. I can finish the project in one day. Moreover, I would be available on chat if you need any further help anytime.
$35 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I can do some excel coding. I have done in my office on large level. Contact me if you think that I am perfact. Thank you.
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I have hands on experience in creating dynamic dashboard, have expertise in advanced excel, vba macros. I have created multiple macros as per requirement for daily/weekly/monthly reports. I have also trained teams for creating VBA macros. Looking for ward to work on this project as my skill profile completely matches the requirement!!! Can work on the project for a long time as well.
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear Employer, You are looking for performance tuning in VBA. I have performed several projects of this type, where I have improved the performance of VBA operations from 30 minutes to 3 minutes, 20 minutes to 20 seconds and so on. Excel operations get slow frequently due to recursive loop operations(multiple loops running within one another ). Slow performance happens due to multiple Excel operations as well. This can be eradicated completely by indexing the Excel sheet, and using indexed search instead of heap search. Using variants also help to perform operations with significant improved efficiency. You can share your sample file and provide me required information about the operation. I can perform adequate re-factoring of the code to provide a satisfactory performance for the user. Your satisfaction is best guaranteed with me.
$20 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of INDIA
Faridabad, India
4.9
261
Payment method verified
Member since Feb 21, 2015

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.