Attendance tracking

My Requirements are as follows

1) Holiday List sheet as list of holidays as per locations - Need a macro to update in Tracker Sheet as H to lookup from Holiday Sheet
( Module 2 as VBA code written which needs to be altered)

2) If i update in cell G10 as 1 it should give a result as AL , M10 as 2 it should give result as CL ... etc as per above table
Give a VBA code script where if i enter 1 it should auto update as AL or CL

PL see attached file.

Insted of changing 1 to CL in each cell the formula in AL10 can be modified as below and for CL you can mark 1 in the date cell.

Please Login or Register  to view this content.

The macro " MarkHolidays " will mark H on the particular dates for the respective places.
The holiday list and "Tracker Sheet" should be for same month, because macro verifies only date not month.

Hi,

Thank You KVS.
I am ok with macro " MarkHolidays . I would require a macro for my 1st requirement which can be made through select statement script by VBA coding,

For Example : Range from 1st to 31st Calender days (E10:AI13) enters as per above table (F3 : Y4)
If i enter manually as 1 in cell , it should auto update as AL
If i enter manually as 2 in cell , it should auto update as CL
If i enter manually as 3 in cell , it should auto update as LWP
If i enter manually as 4 in cell , it should auto update as LOP

Please try

Insted of changing the entry Why Formula cannot be changed. Is there any problem.

See if the attached Attendance workbook will be helpful.
It will work with up to 50 employees, just make copies of the employee sheets.

Pl See the attached file.
Worksheet_Change Event is used.