Assigning task to team members as per their availability

%3CLINGO-SUB%20id%3D%22lingo-sub-2730722%22%20slang%3D%22en-US%22%3EAssigning%20task%20to%20team%20members%20as%20per%20their%20availability%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2730722%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EHi%20Team%2C%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EI%20have%20a%20team%20of%2020%20people%20%26amp%3B%20have%20to%20distribute%20task%20to%20them%20every%20month%2C%20is%20there%20any%20formula%20or%20VBA%20code%20through%20which%20it%20can%20be%20done.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EIn%20attached%20images%2C%20i%20have%20two%20task%20to%20be%20performed%20%3A%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E1)%20In%20tracker%20have%20to%20Mark%20Implement%20%26amp%3B%20Preparation.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E2)%20For%20Implement%20have%20to%20assign%20it%20to%20person%20who%20is%20available%20in%20same%20shift%20on%20same%20date.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E3)%20For%20Preparation%20have%20to%20assign%20that%20task%20to%20people%20present%20in%20shift%201%20day%20before%20%26amp%3B%20that%20too%20except%20Night%20Shift.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EIs%20there%20any%20way%20this%20can%20be%20automated%3F%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Tracker.JPG%22%20style%3D%22width%3A%20628px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F308771i6DDFC9B0EFE90F62%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Tracker.JPG%22%20alt%3D%22Tracker%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3ETracker%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Roster.JPG%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F308772i6D490ABCF0D95FF8%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Roster.JPG%22%20alt%3D%22Roster%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3ERoster%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2730722%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Hi Team,

I have a team of 20 people & have to distribute task to them every month, is there any formula or VBA code through which it can be done.
In attached images, i have two task to be performed :
1) In tracker have to Mark Implement & Preparation.
2) For Implement have to assign it to person who is available in same shift on same date.
3) For Preparation have to assign that task to people present in shift 1 day before & that too except Night Shift.
Is there any way this can be automated?TrackerTrackerRosterRoster

0 Replies