Hi All,

This has been killing me for the past few weeks, I have been searching endlessly around how to do this ,(see attached sheet)
I have created this user form firstly to populate data in to a spreadsheet (Enter Data button).
But next I want to be able to use another button to populate a list box based on either
Training Course
Shift
Operator

So the team leader can choose either "Shift" and list box populates all training required on his shift or choose "Operator" and brings up all of that operators Training required, or simply choose "Training Course" and brings up all the operators that require that training.

Is it possible to do the above? I'm not sure where to start?
Much Appreciate your help!!!
(hope I have explained it properly)
Training Requirements v2.xlsm