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, 10 views)

"Willing to learn" is a great thing, asumner—and I'm not being facetious or even ironic—but there's no way to write a program to do something unless you already know the steps you'd take to do the task manually. Do you? Because I don't :-). If you can write down the steps you would take to create such a schedule manually, then I can show you how to translate them into VBA statements.

Excellent! I have most - but not all - of the logic figured out. It is admittedly cumbersome. I had hoped that someone had already gone through this exercise, but if not, I shall put pen to paper and respond when I have it in a digestible format.

I thank you in advance for your assistance.