Attendance tracking

Gr8 Steven you have solved my 5th requirement

Now there is slight change in Holiday list VBA script where it should match the location and needs to "H" in given date range

For Example : For Location like Belegaum,Kottyam as Holiday date , it should update in tracker sheet as H in given dates.

Please help out