Hello,
I am looking to consolidate a list of employees and training requirements.
I have one sheet which lists employees and what functional roles they fall under.
Another sheet lists training requirements per functional role.
I want to set up a third sheet which would consolidate training requirements per employee.
Example:
Sheet 1
Sheet 2
Sheet 3
Thanks!
I am looking to consolidate a list of employees and training requirements.
I have one sheet which lists employees and what functional roles they fall under.
Another sheet lists training requirements per functional role.
I want to set up a third sheet which would consolidate training requirements per employee.
Example:
Sheet 1
Role 1 | Role 2 | Role 3 | |
Employee 1 | X | X | |
Employee 2 | X | ||
Employee 3 | X | X |
Sheet 2
Role 1 | Role 2 | Role 3 | |
Training Requirement 1 | X | ||
Training Requirement 2 | X | X | X |
Training Requirement 3 | X | X |
Sheet 3
Employee 1 | Employee 2 | Employee 3 | |
Training Requirement 1 | |||
Training Requirement 2 | |||
Training Requirement 3 |
Thanks!