How can I create an attendance report in listed format from XL sheet?
Employee Office Attendance.xlsx
I need to take the data from the attached worksheet and move it to something like the sample below. Really trying not to have to do it manually…..
Any ideas?
-------------------------------------------
Our goal is to have a report that will be able to show us (1) who is in the office regularly each week and (2) which days are the most attended.
We talked about a grid with the days/dates across the top and the names of employees on the left. Each column would be totaled and each row would be totaled and we would have grand totals as well. Each week would have its own work sheet but we would also be able to see monthly totals on the last week of each month. See below example:
Emp Name | Monday – 4/18/22 | Tuesday – 4/19/22 | Total Days in this week |
Emp A |
|
|
|
Emp B |
|
|
|
Emp C |
|
|
|
Total Office used each day |
|
|
|
ASKER