Hey everyone I want to create a workbook that keeps track of certifications of employees across different shifts. My goal is to have a master sheet that i update and have excel create tables in new tabs for each shift. I need the table to update when i change something in the master sheet. Bellow is an simplified version of what i want to do i will be keeping track of around 50 people and around 30 certifications. what would be the best way to do this i would eventually like to create charts that illustrate things like shifts completion percentage for each tool set but i will cross that bridge when i come to it. I just want to make sure that everything will work together in the future.
<tbody>
</tbody>
<tbody>
</tbody>
Employee | Shift | Badges | Task | Tool type | Certification |
john | 1 | yes | 1c | yes | |
Rob D. | 2 | yes | 1a | yes | |
Rob D. | 2 | yes | 2a | no | |
Tom | 2 | yes | 1a | no | |
Joe | 3 | yes | 1a | yes |
<tbody>
</tbody>
Employee | Shift | Badges | Task | Tool Type | Certification |
Rob D. | 2 | yes | 1a | yes | |
Rob D. | 2 | yes | 2a | no | |
Tom | 2 | yes | 1a | no |
<tbody>
</tbody>