Question: show me the VBA code in excel Create application to assign city demand values based on truck capacity. Clear any previous assignment values. For each

show me the VBA code in excel Create application to assign city

show me the VBA code in excel

Create application to assign city demand values based on truck capacity. Clear any previous assignment values. For each truck, first ask user for capacity of each truck and write in "TruckCapacity" range, then use a nested Do Until loop to assign demands until capacity is full (or cities are all assigned). Give user message any time a truck capacity if full. Calculate total number of stops and total driver

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!