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 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
Get step-by-step solutions from verified subject matter experts
