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

Assigning task to team members as per their availability


New Member
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.
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?