Hi All,
I want to make a drop down list to pull the data from the month sheets, showing colour box in the Calendar year sheet. But for each Staff is showing only there own data at the time from the drop list. I not sure if I use a "choose formula or match formula", but how do I do it? Example: on the Month of Jan, a staff has taken a days holiday and the box is blue. I want to see the drop down list for this staff and showing me a colour box in the date of Jan.
I did know how to do it, but forgotten
Cant attached my excel sheet, please link to my dropbox.https://www.dropbox.com/s/etmw96d1hef4bx9/Holiday Chart 2019 DUMMY.xlsx?dl=0
I want to make a drop down list to pull the data from the month sheets, showing colour box in the Calendar year sheet. But for each Staff is showing only there own data at the time from the drop list. I not sure if I use a "choose formula or match formula", but how do I do it? Example: on the Month of Jan, a staff has taken a days holiday and the box is blue. I want to see the drop down list for this staff and showing me a colour box in the date of Jan.
I did know how to do it, but forgotten
Cant attached my excel sheet, please link to my dropbox.https://www.dropbox.com/s/etmw96d1hef4bx9/Holiday Chart 2019 DUMMY.xlsx?dl=0