Hello,
This is my first time visiting the site and am hoping someone can help. I am tracking employee attendance and have a sheet/tab for each month. I'm using the simple AutoSum feature to track their attendance in a "total" column. I also have a year to date sheet that has Jan-Dec. It is on this sheet that I am having a problem. What I want to do is have the attendance data tracked for each employee that month, but employees quit and new one's are coming in from month to month. Is there a way to create a formula that will not only match data by employee but also ADD employee names if they were non-existent the prior month on seperate sheets?
<TBODY>
</TBODY>
This is my first time visiting the site and am hoping someone can help. I am tracking employee attendance and have a sheet/tab for each month. I'm using the simple AutoSum feature to track their attendance in a "total" column. I also have a year to date sheet that has Jan-Dec. It is on this sheet that I am having a problem. What I want to do is have the attendance data tracked for each employee that month, but employees quit and new one's are coming in from month to month. Is there a way to create a formula that will not only match data by employee but also ADD employee names if they were non-existent the prior month on seperate sheets?
| Employee | Month | Month |
| John Smith | 2 absences | 0 |
| Jane Smith | 1 | 5 |
| John Doe | 3 | 1 |
| INSERT NEW DATA | INSERT NEW DATA | NEW DATA |
<TBODY>
</TBODY>
