• 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.

Dynamic Comment

Hi

i want to have a tab with a monthly calendar and another tab for employees leaves and when selecting employee from the drop-down menu,i got comments automatically on dates with leaves on the calendar from leave logs, and this can be changed based on employe selected,is that possible and what can i use to do it
thanks
 

Attachments

  • Book1.xlsx
    14.6 KB · Views: 4
COUNTIFS will test each day of the active calendar to test the day against start and end dates for leave recorded for the given employee.
 
@vletm
thanks for this sample, yes its exactly what I want to do
thanks again, please allow me to send it here again if i have a side questions after I apply it to the whole workbook
 
Back
Top