I have a workbook containing a schedule in a linear format arranged with columns corresponding to Outlook fields to allow import into an Outlook calendar.
Because of various institutional inanities, there still needs to be a calendar view of the schedule in excel format for distribution to departments not sharing outlook access.
I lifted this CalendarMaker macro from the internet:
I need to map cells in the "Subject" field from the linear schedule to the corresponding day on the calendar view. Weekdays have two shifts and weekends have only one shift, so the rows of my schedule will not relate to dates in a static manner from month to month. I am happy to concatenate both shifts in a single calendar cell, but I just can't figure out how to get started on this. Any help? Thanks in advance.
Bookmarks