Trying to get data from a separate workbook. Source data contains number of calls and time spent on calls by individual users daily. I need the data for each user to pull into the destination spreadsheet for each day.
Fingers crossed that someone can help me. Thank You!
DESTINATION SPREADSHEET
SOURCE DATA
Fingers crossed that someone can help me. Thank You!
DESTINATION SPREADSHEET
Date | AGENT NAME | ACD Calls | ACD Time |
4/25/2024 | x | | |
4/25/2024 | x | | |
4/25/2024 | x | ||
4/25/2024 | x | | |
4/25/2024 | x | | |
4/25/2024 | x |
Date | Agent Name | ACD Calls | ACD Time |
4/25/2024 | X | 0 | 1:25:05 |
4/25/2024 | X | 17 | :37:26 |
4/25/2024 | X | 15 | :25:34 |
4/25/2024 | X | 2 | :01:11 |
4/25/2024 | X | 1 | :00:31 |
4/25/2024 | X | |