Macro for Average Allocation.

Hi,
At the outset, let me explain you about the allocation activity that I am doing in excel.

In the col. B, I have the machine names starting from M1 to M14.
In the col. C, I have the test cases to be executed.

Instead of executing the testcases in one individual machine, I am allocating the testcases to the all available 14 machines (here I mean by Virtual Machines).

On an average I allocate 20 Testcases to one machine. The testcases count are combined together to reach the count 20 and allocated to particular VM which is free.

I am doing this as a manual process. Attached the File for your kind perusal.

Can you please guide me in writing a macro for this process. Seek your help please.

Regards,
Sairam Prasath.

How do you know that a machine is "free"? For example why did the first and second test cases get assigned to M1, but the third case get assigned to M2?

If you don't spell out in detail the rule for assigning a machine to a test case (the very algorithm you're asking about) then it's very difficult to write any code.

For example, based on your description so far, I would just assign the first 20 test cases to M1, the next 20 to M2, etc. But I don't really think that's what you want the code to do.