J
jmacvicar
I have a employee job scheduling table that I would like to populate
based on criteria from 2 other tables.
The scheduling table has the employee names listed in each row and
across the top is the period of the day broken into 4 time periods.
The critera tables are:
1. A training matrix that lists the employee names in each row and the
jobs listed across the top. If an employee is trained, the
intersecting cell has a "T". If they are not trained, the cell is
blank.
2. An attendance table that lists the employee names in each row and
if they are absent, there is an "A" in the next cell. If they are at
work, the cell is blank.
I'd like to be able to populate the scheduling table based on whether
they are trained and present at work.
Can this be setup in excel ?
Thanks
Jeff
based on criteria from 2 other tables.
The scheduling table has the employee names listed in each row and
across the top is the period of the day broken into 4 time periods.
The critera tables are:
1. A training matrix that lists the employee names in each row and the
jobs listed across the top. If an employee is trained, the
intersecting cell has a "T". If they are not trained, the cell is
blank.
2. An attendance table that lists the employee names in each row and
if they are absent, there is an "A" in the next cell. If they are at
work, the cell is blank.
I'd like to be able to populate the scheduling table based on whether
they are trained and present at work.
Can this be setup in excel ?
Thanks
Jeff