Good day,
This could probably done trough a VBA action, the only problem, is that i have absolutely no idea how i can do this....
Details;
I'm in a call center, with 44 seats, i want to be able to assign seats, in a specific order (order is already set in cell 1 to 44, from first to assign to last.)
I need to assign those seats based on a specified schedule in 24h format, so when an agent come in, assign first seat AVAILABLE in the list in order, and so on.... And when an agent leaves, this seat becomes available for another agent, to be choosen in order, in the list.
Anyone following me on that?
Is it possible? if yes, i will provide as much info as possible to make this work, but my limited VBA skills cannot compute this one
Bookmarks