simple fast excel macro work
Budget: $30 – $50 USD
I am attaching some sample files. This is simple macro work.
Note that the 2 files already have existing macro. So you need to create a new macro button called "Add WFS Inventory".
The goal is to add NEW shipment quantities into 2 existing files and updating their value.
What you need to do:-
1) Create a new button "Add WFS Inventory"
2) When I click on this, then I should be asked from which is the new shipment quantity file. (This is the file "Shipment(sample)" that I have attached"
3) Then it should ask me to select "WFS Inventory" file (this file is attached as WFS Inventory sample)
3a) It should simple find the Column C (SKU in Shipment(sample) file) and find the same SKU in the WFS Inventory file). Once this is found, it should ADD the new quantity which is column G in Shipment(sample) file in the column L in WFS Shipment file
4) Then it should also ask me to select "WFS Inventory Monitor" file. And then repeat the same, take quantity in column C (SKU in Shipment(sample) file) and find the same SKU in the WFS Inventory Monitor file). Once this is found, it should ADD the new quantity which is column G in Shipment(sample) file in the column L in WFS Shipment file
This is very basic and fast work. I need it by today if possible.
Note that the 2 files already have existing macro. So you need to create a new macro button called "Add WFS Inventory".
The goal is to add NEW shipment quantities into 2 existing files and updating their value.
What you need to do:-
1) Create a new button "Add WFS Inventory"
2) When I click on this, then I should be asked from which is the new shipment quantity file. (This is the file "Shipment(sample)" that I have attached"
3) Then it should ask me to select "WFS Inventory" file (this file is attached as WFS Inventory sample)
3a) It should simple find the Column C (SKU in Shipment(sample) file) and find the same SKU in the WFS Inventory file). Once this is found, it should ADD the new quantity which is column G in Shipment(sample) file in the column L in WFS Shipment file
4) Then it should also ask me to select "WFS Inventory Monitor" file. And then repeat the same, take quantity in column C (SKU in Shipment(sample) file) and find the same SKU in the WFS Inventory Monitor file). Once this is found, it should ADD the new quantity which is column G in Shipment(sample) file in the column L in WFS Shipment file
This is very basic and fast work. I need it by today if possible.