View Full Version : Spreading numbers problems in VBA code

10-05-2015, 12:13 PM
Hi all,
I need your help in the following issue:
In the attached VBA excel file, there are two sheets the first one which is 'Collection' and the second one which is 'Max_Collection'. The Collection sheet includes the code of the model, when you run it, you will see numbers, times, letters are generated. The second one includes the maximum collection number for each company with the container size and type.

What I am trying to achieve is to distribute (spread) the maximum collection number in the 'Max_Collection' sheet for each company within weeks, days, and times that are generated in the 'Collection' sheet in each run.

In the 'collection' sheet the weeks are generated in columns (F, M, T), serial numbers are generated in columns (I, P, W), the times are generated in columns (J, Q, X), and the collection numbers are generated in columns (G, N, U).

I will be very grateful if anyone of you can assist me in this issue asap please. By the way there is a snap shot explains how to spread the numbers in sheet 3.


10-07-2015, 04:43 AM
Please assist me in this problem