Dear Experts,
I've got a task where I need to create an excel template which automatically allocates work based on the work types trained by each team member (Allocation Matrix) and whether they are present for the day to do the work (Allocation Tracker - Present (row # 3)).
Similarly Column E "Case #" I Allocation Tracker will be manually updated for each day on the team Work Load.
Once the VBA is executed then the work Load should get distributed among the Team Members based on their trainings undergone. (Allocation Tracker).
I've designed the excel however need your guidance on how to proceed further.
Thanks for your support.
I've got a task where I need to create an excel template which automatically allocates work based on the work types trained by each team member (Allocation Matrix) and whether they are present for the day to do the work (Allocation Tracker - Present (row # 3)).
Similarly Column E "Case #" I Allocation Tracker will be manually updated for each day on the team Work Load.
Once the VBA is executed then the work Load should get distributed among the Team Members based on their trainings undergone. (Allocation Tracker).
I've designed the excel however need your guidance on how to proceed further.
Thanks for your support.