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!

Attached Files

meeting_schedule.xlsx (12.1 KB, 12 views)