Speed up VBA code for Excel
$30-250 USD
Paid on delivery
I have a VBA code that I run which helps me divide up a larger spreadsheet for customer orders. We have one customer with two sub-units that order multiple parts from multiple locations at once. I would like the macro to look up the parts in our inventory spreadsheet to determine what we have available to ship, look up the sales order number, purchase order number, and sub-unit before creating individual excel files for each location. Right now I am putting the look-ups in before I run the macro to separate into individual files because when I had it do everything it took hours to finish. It does what I need it to do in its current form but it takes about 15-20 minutes to run so I need to find a way to speed it up. Ideally, the macro would create the look ups and separate into individual files without taking more than a few minutes or shorter. I have attached a sample in its raw form and a sample with the formulas and macro. I actually took the formulas out and pasted them into the first row of the columns they would be in because they wont work anyway if not on our server.
Project ID: #16990905
About the project
Awarded to:
Hi, I have multiple years experience in excel, functions and macros. I will help you in optimizing your macro so that it will work fast. Please give me this opportunity to work on your project. Thanks, Peter
34 freelancers are bidding on average $117 for this job
Hello Sir, I am a full time freelancer and can work dedicated on it till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community (ht More
HI, I am good at Excel and vba. I have reviewed the files attached. I would like to review few points in the chat. I can add the formulas automatically I think, you have recorded them in module2. Looking forwa More
Hello, I can help with you in your project Speed up VBA code for Excel. I have more than 5 years of experience in Data Entry, Data Processing, Excel, Visual Basic, Visual Basic for Apps. We have worked on several si More
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.
Hello Sir, I am an expert VBA developer and I would like to work with you on this excel project. Thanks Aanvik
Hello there, This can be speeded by using ARRAYS instead of changing everything in spreadsheet. I have developed more than 500 VBA macros for Windows/MAC I am an expert in Excel/Word/PowerPoint/Outlook VBA/Python with More
Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered fourteen excel vba projects in the past seventy days. Willing to take up your project. Thank you, Regards.
I have excellent command on MS Excel. I understand that the lookups is slowing down your code and I can easily write it in a macro (and any other changes) to speed up the process. I have completed complex projects in E More
Hello, To start with, 15-20 minutes is huge time and taking a look at the file I can guarantee that I can speed up the process a lot. If you like, I can transfer the large excel DB into an Access DB. It can have an More
Hi, I am computer science graduate with more than 3 years of programming in VBA Excel for Macros, as well for automation in Excel Spreadsheet. I have seen your files, and yes there is feasibility to make this process s More
Hello, I went thru the project description and it can be done Discuss with me and I will start by today My previous projects and reviews can be seen in my profile I look forward to hearing from you Thanks Rega More
Hi, I am Lang Lang from China. I am a Senior software developer and I have many years of experience in software development. I developed many apps and websites so I know time is most valuable for us. I will help you More
I worked in many projects for Excel that included macros, most of them for web scraping, dashboard, forms, I have the required expertise for your project.
Hello, i can do this job. Give me more details about it, please check my profile to see my qualifications