Employee Attendance Tracker Template.

keiser_garcia

New Member
Joined
Sep 24, 2024
Messages
2
Office Version
  1. 2019
Platform
  1. Windows
HI,

I am using this template but am being asked for a summary of all employees on one sheet... I would prefer, that each line be the employee's name and the total number of days per column.

Example:

A1 Employee Name 1 A2 Employee 2
B1 Days on Leave 1 B2 Days on Leave 2
C1 Sick Days 1 C1 Sick Days 2
D1 Vacation 1 D1 Vacation 2
E1 Etc... 1 E1 Etc... 2

So on...

This is so managers can see comparisons.

How can I do this?
 

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result
The way you have shown this is confusing. You said "each line be the employee's name" but your example shows all employees on one line. Your first row says A1 and A2 but cells A1 and A2 in Excel are the same column, same with B1/B2. Then you show C1 and C1, which are the same, and D1/D1, E1/E1. It would be better to make a mockup in a worksheet then copy and paste it here.
 
Upvote 0
The way you have shown this is confusing. You said "each line be the employee's name" but your example shows all employees on one line. Your first row says A1 and A2 but cells A1 and A2 in Excel are the same column, same with B1/B2. Then you show C1 and C1, which are the same, and D1/D1, E1/E1. It would be better to make a mockup in a worksheet then copy and paste it here.
I apologize for my explanation...

This is what I would like for it to look like... Please excuse my mock excel,
A
MOCK EXCELABCDEFGHI
1
EMPLOYEE NAME
DAYS ON LEAVESick leave
Vacation

CALL IN
NO SCHEDULED WORKPRESCHEDULE
NO SHOW
WORKED FROM HOME
2A, RAMSES103331
3A, ALEJANDRO11272
4B, RAUL3111
5B, RAUL SR1553232


Currently, it is one tab per employee but I would like to see all the employees with their totals for Management and the tab per employee for the employees during reviews.
 
Upvote 0
There is no way to help with this without knowing what the tab for one employee looks like.

Is there a master list of employees somewhere? If not, the only way to do this is with VBA to loop through all the sheets. How are the tabs on the employee sheets named?
 
Upvote 0

Forum statistics

Threads
1,224,567
Messages
6,179,571
Members
452,927
Latest member
whitfieldcraig

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top