What i'm looking to accomplish is post events from one sheet to the calendar on the next sheet. Simple enough but instead of a big 12 month calendar for each entity, I'm looking to consolidate it into one Calendar view that anyone on my team can view their specific entity and responsibilities. Attached is a mock up of what i'm working with. Sheet 1 contains the calendar with a drop down for month and property, and sheet 2 contains the list of properties and the corresponding events/dates for the entity.
Thanks in advance, any questions or anything i can help with please let me know.
Bookmarks