Forum Discussion
Attendance Tracking
Hi, I'm making an attendance tracker for my employees. I am making a separate worksheet for each month, but each will have the same format. I will be tracking absences, late, excused, etc and totalin...
I would suggest to put all data in *one* worksheet, with columns for date, employee, reason of absence, duration, ... that kind of information. After that it'll be easy enough to create a summary page (using a pivot table) which you can filter for whatever you need.