Speed up VBA code for Excel

Completed Posted 5 years ago Paid on delivery
Completed 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.

Data Entry Data Processing Excel Visual Basic Visual Basic for Apps

Project ID: #16990905

About the project

34 proposals Remote project Active 5 years ago

Awarded to:

TechnoGuruu

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

$155 USD in 3 days
(89 Reviews)
6.0

34 freelancers are bidding on average $117 for this job

jaylancer43

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

$150 USD in 2 days
(752 Reviews)
8.5
cgullapalli

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

$100 USD in 1 day
(900 Reviews)
8.0
schoudhary1553

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

$155 USD in 3 days
(350 Reviews)
8.0
P0L

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.

$150 USD in 3 days
(335 Reviews)
7.3
zekovicm

Hi there,I am Miljan,Excel VBA expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this job ! I can start immediately and finish it within th More

$155 USD in 3 days
(141 Reviews)
7.4
paris2785

Hi, there. My name's Paris Pallas and I'm an Excel expert. Having completed almost 230 projects during the last 5 years successfully I feel really confident in assisting with yours as well. You're welcome to visit m More

$90 USD in 3 days
(242 Reviews)
7.5
aanvikm

Hello Sir, I am an expert VBA developer and I would like to work with you on this excel project. Thanks Aanvik

$222 USD in 3 days
(42 Reviews)
6.6
dvcontact

Hi, You won’t make the right candidate selection without knowing what your project on improving and speeding up your VBA code will look like. Fortunately, I can show you how your job will look like before you award th More

$150 USD in 3 days
(55 Reviews)
6.5
avinav606lx

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

$30 USD in 3 days
(178 Reviews)
6.6
periyannas

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.

$155 USD in 3 days
(111 Reviews)
6.3
archanaoswal

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

$150 USD in 3 days
(93 Reviews)
6.0
sorinacho88

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

$50 USD in 3 days
(57 Reviews)
5.2
madnanayoub

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

$111 USD in 3 days
(34 Reviews)
5.0
draco77

Hey there, From the sounds of it, you need someone to take your Excel project and optimize it to reduce execution time. You need an Excel expert who can write optimized formulas and VBA code. Is that sounds about rig More

$155 USD in 10 days
(18 Reviews)
4.5
nelumindralal

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

$100 USD in 2 days
(29 Reviews)
4.4
langlangFan

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

$155 USD in 3 days
(3 Reviews)
4.2
yh2013

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.

$155 USD in 5 days
(14 Reviews)
3.8
conforti

Hello, i can do this job. Give me more details about it, please check my profile to see my qualifications

$50 USD in 3 days
(10 Reviews)
3.7
lherreraz

Hi there! I read the project's description and I'm sure that I can help you with this. I have a large experience working with advanced Excel, using formulas, functions and Macros using VB, the most important thing is t More

$80 USD in 1 day
(15 Reviews)
3.7
arash18k

I see your Excel files and macros you coded, I have to tell that you mixed the micros that is using so much Excel tools (like selecting, copying, pasting, deleting duplicate values filtering and so on) also you use he More

$45 USD in 1 day
(8 Reviews)
3.7