Equal work allocation via vba

I need to distribute work among the people. In MAYP sheet I have table & according that table I need to perform my task. ASGIN sheet contain data where I need to actual allocate the work. E.g. TUV (SHEET MAYP Column A) have 4 customers then macro should populate data in ASGIN. Please see attached workbook. In short as per the number macro allots work. I have work on one code which I found on Google but it’s not working fine. It’s copying whole row & sometimes gives error. Have look on workbook you will get idea.

Please Login or Register  to view this content.

I need to distribute work among the people. We have employee master in that we have list of employee and benchmark for every employee.
In Daily Task Received table we have total no. of task for day and that total task. we need to distribute between the employee in Work Allocation between employee table
E.g. In Total Task1 received for day is 100 count that distributed in employee 1 40 as per benchmark employee2 40 & balance in employee 3 20 total 100.
I have managed to automate table 1(Daily Task Received) but need help in table 2 (Work Allocation between employee).

Originally Posted by onaik89

I need to distribute work among the people. We have employee master....

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread