firetyrant
New Member
- Joined
- May 13, 2019
- Messages
- 1
I have a quandry. I am trying to create a drop down list or similar to show me All employees and the single task they "HAVE NOT" been trained on yet. I have 52 employees and 20 tasks they need to be trained on. I know I can create a table and add a filter to show ALL employees that have not yet been trained on those certain tasks, but I want to only show a single task by itself and what employees they are. In drop down menu choose "James", returned data only shows the tasks they have not been trained on. Example of what I'm working with so far. Using Excel 2016
[TABLE="width: 500"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Fork Lift[/TD]
[TD]Bailing[/TD]
[TD]Inventory[/TD]
[TD]Shipping[/TD]
[TD]Stocking[/TD]
[TD]Receiving[/TD]
[/TR]
[TR]
[TD]Joe[/TD]
[TD]Trained[/TD]
[TD]Trained[/TD]
[TD]Trained[/TD]
[TD]Not Trained[/TD]
[TD]Trained[/TD]
[TD]Trained[/TD]
[/TR]
[TR]
[TD]James[/TD]
[TD]Not trained[/TD]
[TD]Not trained[/TD]
[TD]Trained[/TD]
[TD]Trained[/TD]
[TD]Not trained[/TD]
[TD]Not Trained[/TD]
[/TR]
[TR]
[TD]Cathy[/TD]
[TD]Trained[/TD]
[TD]Not Trained[/TD]
[TD]Trained[/TD]
[TD]Not Trained[/TD]
[TD]Trained[/TD]
[TD]Not Trained[/TD]
[/TR]
[TR]
[TD]Don[/TD]
[TD]Trained[/TD]
[TD]Trained[/TD]
[TD]Not Trained[/TD]
[TD]Not Trained[/TD]
[TD]Trained[/TD]
[TD]Trained[/TD]
[/TR]
[TR]
[TD]Jake[/TD]
[TD]Not Trained[/TD]
[TD]Not Trained[/TD]
[TD]Not Trained[/TD]
[TD]Trained[/TD]
[TD]Not Trained[/TD]
[TD]Trained[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 500"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Fork Lift[/TD]
[TD]Bailing[/TD]
[TD]Inventory[/TD]
[TD]Shipping[/TD]
[TD]Stocking[/TD]
[TD]Receiving[/TD]
[/TR]
[TR]
[TD]Joe[/TD]
[TD]Trained[/TD]
[TD]Trained[/TD]
[TD]Trained[/TD]
[TD]Not Trained[/TD]
[TD]Trained[/TD]
[TD]Trained[/TD]
[/TR]
[TR]
[TD]James[/TD]
[TD]Not trained[/TD]
[TD]Not trained[/TD]
[TD]Trained[/TD]
[TD]Trained[/TD]
[TD]Not trained[/TD]
[TD]Not Trained[/TD]
[/TR]
[TR]
[TD]Cathy[/TD]
[TD]Trained[/TD]
[TD]Not Trained[/TD]
[TD]Trained[/TD]
[TD]Not Trained[/TD]
[TD]Trained[/TD]
[TD]Not Trained[/TD]
[/TR]
[TR]
[TD]Don[/TD]
[TD]Trained[/TD]
[TD]Trained[/TD]
[TD]Not Trained[/TD]
[TD]Not Trained[/TD]
[TD]Trained[/TD]
[TD]Trained[/TD]
[/TR]
[TR]
[TD]Jake[/TD]
[TD]Not Trained[/TD]
[TD]Not Trained[/TD]
[TD]Not Trained[/TD]
[TD]Trained[/TD]
[TD]Not Trained[/TD]
[TD]Trained[/TD]
[/TR]
</tbody>[/TABLE]