Quick Macro VBA Fix with a view to further work
Budget: £10 – £20 GBP
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:
http://somup.com/c0VZoxx0yy
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:
https://prnt.sc/Yt4uT5Uez80O
I have attached the macro and a sample csv file (to run the macro) here.
Please see the screen recording below which better explains the issue:
http://somup.com/c0VZoxx0yy
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:
https://prnt.sc/Yt4uT5Uez80O
I have attached the macro and a sample csv file (to run the macro) here.