• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Master calendar showing events form different dates

N

Nicki

Member
I have used excel template to show all the events happening in each employee calendar colour coded, now i want to be able to show all the events for all employees either by appearing a different symbol or the actual name of event listed in a cell. i hope i have explaied it good enough please ask me if not clear. file attached. Many Thanks for your help :)
 

Attachments

I'd recommend setting up another calendar for that. Since entire calendar set up is dependent on Employee and Year selection from Data validation.

This looks like same template as the one I helped before, to set up second calendar. Check the link on how to set up 2nd calendar and then apply different set of validation and conditional format on the second calendar.

http://chandoo.org/forum/threads/attendance-calendar-help.30988/#post-184476
 
Hi Chihiro, many thanks for your quick reply and time. I apologize that I have not explained my question properly. I am trying to set up a seperate caledar in a new sheet that shows all the events on column E (ILEPOs Tracker sheet) for a specific date.(for example on 10 January) 5 events going on for different employees and we want to see them in one cell.
similar to this:
upload_2016-9-16_21-16-17.pngupload_2016-9-16_21-16-17.png
 
You must log in or register to reply here.
Back
Top