I was hoping to get some guidance here for a Leave calendar I want to create. I have the calendar set up with dates across and the names/IDs down (see attached sample). What I want to do now is, use a report I am getting from the system that shows the start & end date of the leave of a person/ID and have this information populate the calendar with an "x" on the days that fall within the requested leave dates from the report.
My problem is not getting the individual days populated with the "x" (using >= and<=), what the problem is,
a) on the report, someone can have multiple requests for leave (eg. 1st May - 5th May and another request from 7th June 15th June), how can I capture all requests of a person (with same ID) and have all requests populated in the calendar
b) how do I find the values in the report (based on the ID on the calendar) considering that someone can have multiple requests in the report (so vlookup is not an option)
Hope this is not too confusing.
Thanks so much for your time and help in the little project.