• 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


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

Automated Task Allocation Tool


New Member
Dear All,

Please help.

I need help on creating Task Allocation.

Sheet 1: Total No. of Users - there will be a check box to select the users who are present/available for that day. Users will be categorized based on the criteria. Task can Be classified to P1, P2, P3, P4. There should be a option to customize this task.

Sheet 2: Data dump will be added here, Column D contains criteria P1, P2, P3 and P4. All the task should be divided equally among the available resource on that day, when macros are run. In Coulmn E, users name should be listed.

When exported the excel workbook of Sheet2 will users allocation should be generated in email to send.