I need to create a Macro to calculate the shipping cost of a consolidated shippings.
The project would be:
· Create New consolidated
· Edit Consolidated
1)Input WR ( wr is the shiping bill)
- Nº WR
- Nº of packages ( If the Nº of package is more than 1, we need to add weight, dimensions, Volume weight for each Package)
- Weight ( KG)
Dimensions: Large x width x height
Volume weight = Dimensions/5000
To see the costo of shipping, we need to know if the Weight is more than Volume Weight. ( if the Nº of package is more that 1, we need to sume each volume weight or weight). We need the bigger of them.
2) Administrative Cost
There are some cost to make the shipping, so we need to add it to the consolidated.
Is 4 or 5 inputs
We need to select the Consolidated Number and Add/edit/delete WR's.
Here we need the list of WR by Consolidated, all the WR's + Administrative Cost and TOTAL.
31 freelancers están ofertando el promedio de $122 para este trabajo
HI I am an excel-vba Expert and I can finish your project so fast pm me to discuss more .......................................................................
Hello, I would gladly hear more details on the project! I'm a VBA expert, especially proficient in Excel automation. Some sample data would be very helpful. Regards