Create a Meeting Schedule
I want to have an Excel Spreadsheet organize a day of meetings in a conference room.
I have (X) employees and we have (Y) meetings. All meetings are the same length of time. Only one meeting can take place at a time. Some people sit in multiple meetings, some sit in a single meeting. I want to sort my daily meeting schedule to accomplish the following:
- Prevent people from sitting in consecutive meetings. Ideally maximize the time between meetings for every employee that sits in multiple meetings.
- Run the meetings that have the highest attendance earlier in the day.
- Identify ahead of time which meeting needs to go first or last. This is a “want”, not a “need”; the other requirements are “needs”.
File is attached. Ideally I would like a macro (or some automated technique) to review the grid and assign a meeting time for each meeting.
I have created macros; I have not yet gotten into VBA programming, but I am willing to learn!
|