Hi excel experts!
I want to create a schedule that shows our undergraduate and graduate courses by day over the week to identify the scheduling overlaps.
Is there a way to have a workbook with one tab listing the courses, days, times, course code and name, and prof. And a second tab with the days of the week and hours with courses showing by day?
I found this thread about autofilling a calendar (excel-general/1101230-how-to-build-auto-fill-calendar-on-excel.html) which is close to what I want, but I don't need the full month, only 1 week.
Needs:
- time duration...maybe replacing the 1 - 10 on the left hand side?
- colour coding to distinguish between undergrad and grad
- courses listed on the same day at same time or overlapping time to somehow show side by side
- ability to filter based on criteria in columns on source tab (ie. filter by Session, Course code, instructor...etc)
Below is a mock up of an idea but I don't know how to get the week to populate automatically. I have about 110 courses so I expect the schedule tab to be a big worksheet. I'm also open to only having the course code listed on the day and time.
Any advice or suggestions appreciated.
Thanks!
Mike
P.s. thanks alansidman!
Bookmarks