• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Macro for Average Allocation

SAIRAM2014

New Member
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.
 

Attachments

  • AllocationMacro.xlsx
    9.4 KB · Views: 6
Hi Prasath,
Welcome to the forum...

I am not getting any idea, If you clarify more about your outcome one of our member will surely do the needful.

Can you clarify more with step by step?

Thank you.
 
Back
Top