Simplifying a task assignment process, where 2000 tasks are broken up among 10 workers.

Ok, I’ve got a problem I’m trying to simplify.

Every day, I receive a Csv list of 2000 tasks over email that I need to split between 10 employees. These employees have a 20 percent chance at completing the task successfully - if they fail, the task shows up on the Csv list the next day to be assigned again, along with other new tasks. I need to track what tasks have been completed, failed, attempted, and are brand new. I also need to send each employee their task list and record their actions.

To do this, I’ve basically built a macro that automatically ingests the Csv into a master list based on unique ID, marrying up past efforts with the current Csv. Then, it splits up that list and sends each of the 10 employees their share of tasks. The way this is shared is each employee has their own excel file, which updates on open. At the end of the day, each employee excel file reports back to the master file, and then it repeats this entire proces when receiving the new Csv the next day.

This macro system works… and believe it or not, is 10x simpler than the legacy system. However, I can’t shake the feeling there is an easier solution. Thoughts on doing this without macros? I don’t want everything to suddenly break in 6 months.

Constraints: 1. For now this must be in excel. In the future we will be looking at specialized software. 2. I can’t have all the enployees share a single sheet due to business restrictions. 3. What makes this tough is the Csv data coming in and having to marry with each employee action the day before.