I have a daily dashboard for a call centre where we input conversions, calls handled, talk time (broken down to hours and minutes) as well as opportunities and dials per hour. As this is daily and the call centre is shift patterned I will not necessarily have the same staff on every day. I have to open a excel downloaded from software called CCM Web each day and amend and tidy up on one tab. I have the above information on a separate tab with formulas which need to be filled by name of the call centre agent rather than having to manually add it each day (43 in total) I can attach a example of the spreadsheet if needed.
Solved by I. F. in 16 mins