Need to create list from Excel database all within the same Workbook

Hi Everyone

I work at a school and our district just started using a new student database that can export all information as an Excel file. However, it cannot create blank class lists of all the students in a single class.

I want to create blank class lists for all the different classrooms based on the Classroom Division and their Grade (some classes have 2 grades) from the database that list all the students. I want to do this within Excel only (I know this can be done with mail merge with Word but I want to keep it in one program to keep it simple for other staff). So my first worksheet called DATA has columns for students first name, last name, grade and divisions.

I want to be able put on worksheet2 to have all students in Division 1. So the criteria has to be all students in Division 1 and then organized by grade and then last name and then first name.

Is this possible on Excel?

Thank

Peter

Hello Peter
The simple answer is probably, yes. From your brief description I would probably have an Excel Table for my main data and then use a Pivot table(s) on another sheet(s) to filter and sort the data you wish to see.

DBY