Forum Discussion
lauren3
Jan 30, 2019Copper Contributor
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...
JKPieterse
Jan 31, 2019Silver Contributor
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.