I've got a list of 8-10 candidates that are doing a series of back to back interviews with 7 interviewers. Is there a way using MS Excel to create a master schedule that will auto populate such a table?
9:00 am 9:20 am ........ 5:00 pm Doctor A: Candidate #1 Candidate #2....... Candidate #8 Doctor B: Candidate #4 Candidate #3....... Candidate #6
Doctor C: Will interview only 5 candidates Doctor D: ditto
Doctor E: Will interview only 4 candidates Doctor F: ditto Doctor G: ditto
Setting up scheduling is probably easier to do with copy and paste operations than to try and set up a macro or get Excel to create the whole set of tables. You certainly don't need to type the list of candidates over and over but writing any sorting schemes would take longer than just moving and shifting columns of names by hand.
I'm sorry Steve, i didn't quite finish my train of thought there.
The other part of this project is that (after the master schedule is set) we'd like to give each candidate a list of doctors that he/she will be interviewing without throughout the day.
I realize this is not over complicated task and as you point out could be accomplished by copy/paste command. But we have a series of these day-long interviewed coming up in the next few weeks.
There's some other variables that i haven't mentioned because i wanted to keep my post simple. Actually, the secretary that i'm doing this work for is not very knowledgeable in MS Acess/MS Excel and i'm trying to make things easy for her. Just thought there might be an easy way to automate some of the process involved.