Forgive me if this is not the right place for the post - I'm new to the forum.

My problem is this - I have an Excel spreadsheet that I am using as a student "database". I want to create another sheet within the workbook that has the students sorted by grade, that only contains some of the headings from the original sheet. I know I've worked in a workbook that had a similar set up, but did not create it. Also, is it possible that when the original sheet is updated or additional students are added, that the 2nd sheet will also updat??

Any help would be great!