Closed

Quick Macro VBA Fix with a view to further work

Job Description:

We have an issue with one of our Excel VBA Macro's, which is that upon running, it is deducting values from column K on the "Stock Management" sheet twice.

Please see the screen recording below which better explains the issue:

[login to view URL]

You will see it updates "on hand" value in BYOPS4, BYOPS5 and BYOXBX correctly, but it removes the quantity twice from the associated sku on Stock management sheet.

I am pretty certain the issue is related to the VBA module 3, as shown here:

[login to view URL]

I have attached the macro and a sample csv file (to run the macro) here.

Skills: Excel, Visual Basic, Visual Basic for Apps, Data Processing, VB.NET

About the Client:
( 148 reviews ) Wootton, United Kingdom

Project ID: #35833679

20 freelancers are bidding on average £27 for this job

zu02

Hi I can fix your xlsm issue. I am an Access/Excel/SQL/VBA expert and mathematician from Georgia, working as a full-time freelancer. Over the past 20 years, I have developed a wide range of accounting, economics, stati More

£20 GBP in 1 day
(53 Reviews)
6.2
usmanbashir12100

Hi, I can help you to enhance and automate your business and work-related tasks based on 6+ Years of experience in Excel, Macro, and VBA development. Having worked as a controller, business consultant, and project man More

£80 GBP in 7 days
(12 Reviews)
5.3
MamukaB

Hello, I have read project details and have check files. I can help with this project to correct code. Can do within few hours I have 16+ year experience in Excel, Excel VBA, Python and have 100% feedback You can trust More

£20 GBP in 1 day
(54 Reviews)
5.0
NaderShehata

Hey sir, it seems that you have a macro sheet that doesn't work as expected according to the video you attached. I checked the video and the macro file and yes macro 3 has an issue in calculations Please check this si More

£10 GBP in 1 day
(7 Reviews)
3.8
mohamedahmedmoha

Hi, I have gone through your project, my expertise areas are bookkeeping , business plans , payroll, excel sheets , account and financial modeling. I can create payroll, maintain bookkeeping and all accounting works ve More

£15 GBP in 7 days
(7 Reviews)
3.6
mna9226

Hello, I have seen the video and understood the problem. I can fix this. Please review my profile as i have below relevant skills and experience. Excel Advanced VBA Google Sheets Apps Script Google Data Studio Google More

£20 GBP in 1 day
(7 Reviews)
3.0
ManormaShehzadi

I can perfectly help you with that. I am a professional Data Analyst and Excel expert holding years of experience in utilizing advance level tools and functions of Excel (including VBA and Macro) to perform Data Analys More

£20 GBP in 1 day
(5 Reviews)
2.5
Harshu1912

Dear hiring manager!! I can fix the VBA macro according to your need!! I have read the project description & i ensure that it doesn't take much time... Will glad to have you in the chat box... Thanks Kind regards,Harsh

£15 GBP in 3 days
(1 Review)
2.2
vishalk41383

My name is Vishal. And I am a professional data entry operator. Ability to multitask effectively. Strong written and verbal communication skills. Ability to perform repetitive tasks with a high degree of accuracy. Comf More

£15 GBP in 7 days
(0 Reviews)
0.0
eshitabokshi1909

Dear hiring manager, I can do your job with 100% accuratiy within few hours. I have such projects for a long time. Waiting for your response Thank you

£15 GBP in 7 days
(0 Reviews)
0.0
amitdubey892001

Hello sir i am a software devloper and data entry operator and BOTH FOUR YEAR OF EXPERIANCE OF 4000 PROJECT SUBMIT ON 100 % ACCRACY TO SUBMIT THE PROJECT. THEN THE PROJECT SUBMIT THE BEFORE TIME AND SO THE YOU CAN G More

£15 GBP in 2 days
(0 Reviews)
0.0