Home

Attendance Tracking

%3CLINGO-SUB%20id%3D%22lingo-sub-328287%22%20slang%3D%22en-US%22%3EAttendance%20Tracking%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-328287%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I'm%20making%20an%20attendance%20tracker%20for%20my%20employees.%20I%20am%20making%20a%20separate%20worksheet%20for%20each%20month%2C%20but%20each%20will%20have%20the%20same%20format.%20I%20will%20be%20tracking%20absences%2C%20late%2C%20excused%2C%20etc%20and%20totaling%20each.%20I%20would%20also%20like%20to%20be%20able%20to%20track%20six%20months%20worth%20of%20attendance%20on%20each%20month's%20worksheet.%20I%20have%20the%20tables%20for%20the%20actual%20tracking%2C%20as%20well%20as%20the%20table%20for%20the%20six%20month%20tally.%20My%20question%20is%2C%20I%20would%20like%20to%20have%20an%20'Associates'%20worksheet%20where%20I%20can%20put%20the%20associate's%20name%2C%20date%20of%20hire%2C%20and%20job%20title%20and%20I%20would%20like%20to%20pull%20this%20information%20onto%20each%20month's%20attendance%20tracker.%20For%20example%2C%20I%20would%20like%20to%20just%20add%20a%20new%20associate%20into%20the%20associate%20worksheet%20and%20have%20it%20update%20the%20associates%20on%20the%20monthly%20trackers%20automatically.%20I%20would%20also%20like%20to%20make%20sure%20if%20I%20filter%20on%20the%20associate%20page%20that%20it%20will%20adjust%20accordingly%20on%20the%20monthly%20trackers.%20(This%20is%20the%20part%20that%20I%20am%20currently%20struggling%20with%2C%20it%20is%20not%20maintaining%20the%20rows%20of%20data%20when%20I%20filter%20on%20the%20Associates%20worksheet).%26nbsp%3B%20Thank%20you%20in%20advance%20for%20your%20input%2C%20I'm%20stumped!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-328287%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETraining%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-328544%22%20slang%3D%22en-US%22%3ERe%3A%20Attendance%20Tracking%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-328544%22%20slang%3D%22en-US%22%3EI%20would%20suggest%20to%20put%20all%20data%20in%20*one*%20worksheet%2C%20with%20columns%20for%20date%2C%20employee%2C%20reason%20of%20absence%2C%20duration%2C%20...%20that%20kind%20of%20information.%20After%20that%20it'll%20be%20easy%20enough%20to%20create%20a%20summary%20page%20(using%20a%20pivot%20table)%20which%20you%20can%20filter%20for%20whatever%20you%20need.%3C%2FLINGO-BODY%3E
lauren3
Occasional Visitor

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 totaling each. I would also like to be able to track six months worth of attendance on each month's worksheet. I have the tables for the actual tracking, as well as the table for the six month tally. My question is, I would like to have an 'Associates' worksheet where I can put the associate's name, date of hire, and job title and I would like to pull this information onto each month's attendance tracker. For example, I would like to just add a new associate into the associate worksheet and have it update the associates on the monthly trackers automatically. I would also like to make sure if I filter on the associate page that it will adjust accordingly on the monthly trackers. (This is the part that I am currently struggling with, it is not maintaining the rows of data when I filter on the Associates worksheet).  Thank you in advance for your input, I'm stumped!

1 Reply
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.
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
21 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies