The attached workbook has multiple macros. All macros works as intended. Neeraj from this site helped me with the change vent macros. Requesting a change in the worksheet change event macro.
This is a suggestion from the users of the worksheet.
Instead of allocating each task, users are suggesting first to select the Planners from the drop down list in column N and after completing the selection, click the ''allocate task'' button to send all the tasks in one go.
Not sure whether to separate the auto date population macro, if task allocation macro need to undergo major changes.