Task Allocation

[Power Puneeth]

Hi All,

I am running a business where i have to allocate the task to employees daily. Task number varies daily but number of employees remain same.

Condition:
In the attached excel file i gave condition box if i enter 50 automatically Task1 should allocate to Employee1 and Task 2 should allocate to Employee2 and it should continue the same flow, once Task5 is allocated to Employee5. Task6 should allocate to Employee1 again and Task7 should allocate to Employee2. It should continue this process until each employee get 50 Task.

I require employee name should populate next to the task name like.,

Task1 - Employee1
Task2 - Employee2

Its looks simple thing but i am doing manual work daily its create lot of manual intervention.


Regards
PP

[Mumps1]

Copy and paste this macro into the worksheet code module. Do the following: right click the tab name for your sheet and click 'View Code'. Paste the macro into the empty code window that opens up. Close the code window to return to your sheet. Enter a value in I4 and press the RETURN key.

Please Login or Register  to view this content.