EMP ID | EMP Name | Date | Job | JOB # |
1 | John | 1/1/17 | Manager | 1 |
1 | John | 1/2/17 | Manager | 1 |
1 | John | 1/3/17 | Employee | 2 |
2 | Mary | 1/1/17 | Employee | 2 |
2 | Mary | 1/2/17 | Employee | 2 |
3 | Peter | 1/3/17 | Manager | 1 |
4 | Paul | 1/4/17 | Employee | 2 |
<tbody>
</tbody>
Hello all-
I am creating a converter for payroll files pulled from POS data. I need to write a VBA code that checks that the same employee is clocked in as the same job for the date range. So in this example Employee #1 John is the only employee in violation because during this period he has two unique jobs (Manager and Employee). I would like a msgbox to pop up stating that employee #1 John is in violation of the policy so the person entering data can fix the incorrect entry manually. Some employees will have only 1 row (just one day of working ilke Peter and Paul) some will have multiple (like Mary and John). The report pulls with both a numerical and string value for each employee and job type.
Appreciate any feedback!