I need a way to automatically update the “Calendar View” worksheet (see example) with each new entry I add to the “Room Assignments & Dates” worksheet. Additionally, the “Calendar View” should somehow flag/highlight when there’s overlapping assignments, or, overbooked rooms. Presently, I have to manually add/edit each row in the “Calendar View”.

Additional info: Most rooms will allow for two people, so maybe I’d need to create room numbers that reflect that, e.g. Fake Room 201 holds two people, so maybe the room numbers needs to be 201-1 and 201-2, showing that there’s two beds in one room?…)

​I need a way to automatically update the “Calendar View” worksheet (see example) with each new entry I add to the “Room Assignments & Dates” worksheet. Additionally, the “Calendar View” should somehow flag/highlight when there’s overlapping assignments, or, overbooked rooms. Presently, I have to manually add/edit each row in the “Calendar View”.Additional info: Most rooms will allow for two people, so maybe I’d need to create room numbers that reflect that, e.g. Fake Room 201 holds two people, so maybe the room numbers needs to be 201-1 and 201-2, showing that there’s two beds in one room?…)  Read More

​