Hello all,

Below i have attached a sample of what i want to achieve through automating my report. I rank about 20 agents or so every week, then make a schedule for them. This sample reflects 30 minute time frames throughout the day. I need help automating some kind of indication identify what activity each scheduled agent will be doing at each given 30 minute time frame. Any help would be GREATLY appreciated!

Sample.xlsx