Filtering Data

[epson661]

Hey guys, I am new to VBA Macros and formulas within excel and I currently am struggling with my excel work. I would like to filter data using either a drop down box or combo box. My spreadsheet consists of students with different grades for the subjects that they do and this page is meant to filter it to a specific subject for example Maths. Each subject has four columns which need to be shown: student target grade, target grade points,current grade, current grade points.

I would like to know how I can filter the data to just show each subject department using a drop down menu, combo box or buttons.
Thanks in advance

 

[auroralily]

This is usually possible without macros - exactly how is your data set out? A screenshot of your layout will make it easier for people to help you.