bdl004
01-11-2012, 06:42 PM
Hi Everybody,
I have been given the task of organizing around a hundred volunteers to complete around 90 different jobs, most of which are on different dates and times. All of these people have submitted an availability sheet giving times where they would be able to volunteer. I have been attempting to do this by hand with little success. My question is whether it would be possible using excel or simple VBA to automatically sort the volunteers in to jobs that fall on the same date and time that the person is available?
For example, I have column "A" giving names and columns "B" through "D" giving that person's available dates and times. I then have column "E" showing a type of job, and column "F" showing the time commitment. I would like to have the output showing the name of the person and the job they have been assigned.
Thanks in advance to anyone who could point me in the right direction!!
Brett
I have been given the task of organizing around a hundred volunteers to complete around 90 different jobs, most of which are on different dates and times. All of these people have submitted an availability sheet giving times where they would be able to volunteer. I have been attempting to do this by hand with little success. My question is whether it would be possible using excel or simple VBA to automatically sort the volunteers in to jobs that fall on the same date and time that the person is available?
For example, I have column "A" giving names and columns "B" through "D" giving that person's available dates and times. I then have column "E" showing a type of job, and column "F" showing the time commitment. I would like to have the output showing the name of the person and the job they have been assigned.
Thanks in advance to anyone who could point me in the right direction!!
Brett