In Progress

Optimize Excel Macro(s) on Spreadsheet

I have a series of scripts coded in Microsoft Excel (Excel 2013) that I need optimized.

Some functions are not working properly and others I feel like could work more efficiently.

When optimizing, I need the code commented and notes put in so I know what's going on (if it differs drastically from how it's done now) since I might need to add/remove functions at some point.

Currently, the sheet uses a lot of do/while loops, with lookups spreadsheet across a few sheets...everything is pretty self explanatory for someone who's done this before.

Skills: Excel, Microsoft, Visual Basic

See more: microsoft excel spreadsheet, uses excel, microsoft macro, excel uses, spreadsheet microsoft excel, excel 2013, excel macro add, sheet excel visual basic, 2013 excel visual basic, remove functions, excel 2013 visual, excel 2013 macro, macro spreadsheet, visual basic scripts, point excel, add excel macro, microsoft excel 2013, visual basic excel 2013, microsoft excel macro, excel 2013 visual basic, optimize code, macro add, functions spreadsheet, code spreadsheet, excel macro sheet

About the Employer:
( 12 reviews ) Riverview, United States

Project ID: #5082417

Awarded to:

zExcel

I'll be happy to help you with this task. Please send the file in your reply and I'll review it and get back to you with my opinion while the question remains open (i.e. before any commitment) .

$250 USD in 1 day
(14 Reviews)
4.4

26 freelancers are bidding on average $288 for this job

Teloquence

Consider it done. Check my past reviews for your reference. Eagerly waiting for your reply so that i can start with the implementation.

$421 USD in 2 days
(155 Reviews)
6.5
hossionsumon

Dear sir, Experts and experience team here to do the jobs very fast accurate. Lot's of experience similar project.Can i help u...

$515 USD in 7 days
(77 Reviews)
6.2
deepbluetech

Hi lorien1973, Had a look at the example code and studied the requirement. I can help in further optimizing and adding necessary comments to the Excel 2013 based macro(s). I am assuming the work will carry on for More

$300 USD in 7 days
(116 Reviews)
5.6
maverick44000

Hi Lorien. I am quite comfortable in VB macros (the script in Excel, you are referring to) written to achieve customized functionality in Excel. Kindly look at the Excel projects, I have done so far and the feedback co More

$500 USD in 4 days
(23 Reviews)
5.2
sonarkaushik

Sir, I am well versed in this kind of jobs and can do your project as per requirement. Refer my online work portfolio at http://bit.ly/Lta2EN Looking for further discussions in this matter. with than More

$289 USD in 5 days
(24 Reviews)
5.2
northwolves

Hi I'm expert of Excel,your project seems easy for me.Provide more details,please. I can solve it for you within 2 days. Zhining

$250 USD in 2 days
(57 Reviews)
5.2
dpune

Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at my feedback to know more about me and my work. Waiting for more details along with posi More

$277 USD in 10 days
(26 Reviews)
4.8
elMancha

Hello there. I have high Excel and Visual Basic skills with great professionalism. I study electronics and computer engineering at Oporto university and I'm looking for work to fill the blanks on my schedule. I' More

$250 USD in 3 days
(28 Reviews)
4.7
expertatwork

Hey lorien1973, Can you please share the excel tool that you are using ? Looks like the volume of work is huge ? Or have you posted in the wrong category (250$ and above)? Please reply and we can discuss further, thank More

$250 USD in 5 days
(53 Reviews)
4.7
jaylancer43

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 More

$277 USD in 7 days
(31 Reviews)
4.6
satsin7

Sharing with a model I am working right now for you to assess. We can discuss after you share yours with me. https://www.dropbox.com/s/hiske0fx307g090/loan_interest_model.xlsm

$250 USD in 3 days
(19 Reviews)
4.6
Edison1983

*****I've done lot of Similar Work. Please check the below links for samples:******* https://www.freelancer.com/projects/4962719.html https://www.freelancer.com/projects/Exceldocumentrepair.html Good Day!... I'm a More

$277 USD in 0 days
(11 Reviews)
3.7
paris2785

VB, VBA and Databases expert for over a decade. Master in Information Systems. I have delivered similar projects in the past. I'll complete your task and send you photo screens. If you are happy you'll award me More

$250 USD in 7 days
(4 Reviews)
3.6
dviruki

Hi! I understand what you need and can do this. I have 12 years of extensive Excel and VBA experience. and do VBA coding on a daily basis. I have prior experience in code optimization and know how to deal with such tas More

$250 USD in 3 days
(14 Reviews)
3.5
tomislav1975

I think I can help you with that. I'm VBA/ Excel expert (you can check my profile) and I would love to work on this project. Please contact me on PM for details. With regards, Tom

$300 USD in 7 days
(4 Reviews)
3.3
inoussakabore

I work with VBA excel there is 4 years. I have already done many automation using VBA Excel. For exemple, i have already automate the production of statistical yearsbooks. I am ready to start

$263 USD in 3 days
(2 Reviews)
3.3
Aldo21

Hi: I can do this for less than 100 USD but it wont let me, please post another project so you can select a lower range. About excel, im VBA expert, check my profile, unlike most developers, im engineer so i know ho More

$250 USD in 5 days
(8 Reviews)
2.9
benefitworks

Hi Sir, I have 4 years of excel development work. I have created excel macros for employers like you in freelancing. You can view their feedback as well. I can understand the VBA macros written by others just by glan More

$277 USD in 5 days
(3 Reviews)
2.5
AccuPro

Hello, I can help. I can already see a place where there is s mistake! You may send me spreadsheet as well. Best regards, AccuPro.

$250 USD in 3 days
(3 Reviews)
2.4
outsourcer9

Hi Lorien, Hope you are doing fine. This is Leela and I worked on the "Excel Data Entry - Categorizing Items Needed" for your website. I just checked your website homenyard.com and I see it is still loading pret More

$250 USD in 3 days
(1 Review)
2.4