#1
|
|||
|
|||
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! |
#2
|
||||
|
||||
"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.
|
#3
|
|||
|
|||
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. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Schedule Converging | andrew22xc | Excel Programming | 8 | 06-01-2015 10:44 PM |
How to delete attendees to a meeting without cancelling meeting | PaulaG | Outlook | 1 | 11-12-2014 07:08 PM |
Create an attendance sheet for monthly club meeting | jcc285 | Word VBA | 0 | 08-30-2014 09:34 AM |
Getting Error when I schedule a meeting in outlook | ms3433 | Outlook | 1 | 09-05-2013 11:03 AM |
Need to Create a Resource Driven Schedule | gamer83 | Project | 2 | 05-24-2011 03:56 AM |