Hello Guys,


I am a regular user of excel. I am currently working as an HR Coordinator. We have an attendance tracker were we manually mark the absenteeism. Now i need help in creating an excel file which is divided into 3 sheets.

1 sheet:1 tab- direct serial number of the staff absent
2 tab- selecting the date on which the staff is absent
2 sheet: Annul attendance for the year 2014 along with total present days, total absent days

3 sheet:Automatic updating a new staff details, which directly allows you to add the name in the Annual Attendance sheet no 2.