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