I'm sorry but that's too much coding for me to do. I thought you initially wanted to just get a list of who was available--which I was able to accomplish through simple SQL.
What you want to achieve (actually assigning tasks) must be done via VBA. I suggest making a new post and seeing if anyone will undertake this.
What you want to achieve (actually assigning tasks) must be done via VBA. I suggest making a new post and seeing if anyone will undertake this.