Excel calendar question

I found an Excel formula that will allow me to list Dates and Events in one sheet, and create a calendar in another that will populate the dates with the events.  What I am having trouble doing, is adding a second column worth or information.  I have attached the spreadsheet, and what I want to do is add Column E, "Room", to the Calendar along with Column C, "Activity".
Michael PaxtonProcess EngineerAsked:
Who is Participating?
junholeeConnect With a Mentor Commented:
is this what you need?
Here's an option. 2 new fields were added to the Activities tab, Room and Activity and Room.  Activity and Room column concatenates the Activity and Room number columns. Conditional formatting had to be modified to accept the changes.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.