Employee Attendance Tracker Template.

[keiser_garcia]

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?

 

[6StringJazzer]

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.

 

[keiser_garcia]

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 EXCEL	A	B	C	D	E	F	G	H	I
1	EMPLOYEE NAME	DAYS ON LEAVE	Sick leave	Vacation	CALL IN	NO SCHEDULED WORK	PRESCHEDULE	NO SHOW	WORKED FROM HOME
2	A, RAMSES	10	3	3	3		1
3	A, ALEJANDRO	11	2		7		2
4	B, RAUL	3	1		1		1
5	B, RAUL SR	15	5		3	2	3	2

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.

 

[6StringJazzer]

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?