Select added value from dropdown menu, program output

[Aleksm]

Hello, I need help with the following. Can somebody help me?

"For easier management of the list of participants in internal courses"

-Data that needs to be inputed (name, surname, department in which the employee works and date of participation)

The program needs an option of output:
1. all participants of one department ordered by date (select department and then the output should be the names and surnames of participants from that department ordered by date )
2. select one participant then the program outputs dates of participation
3. select one date and then the program outputs all the participants

[mana]

You should use Autofilter or Advanced filter.