Sometime in the past year, the new deodorant sticks (white) make me itchy as all hell, and breaking out with huge red under arm rashes. What gives? did they change something here? I used to love old spice but now i cant get near the stuff.
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: