cross referencing a work sheet

[ExcelTeacher]

I have a work sheet with following info :
Student Id Student name Grade Course 1 Teacher 1 Course 2 Teacher 2 Course 3 Teacher 3

I would like to be able to make two new work sheets with the info sorted out as follows :
Teacher 1 (Course info)
List of students per course (with their info)


Course 1
List of students (with their info)

Is this possible?

 

[Andrew Poulsom]

If you set out your data in first normal form (one row for each combination of student, course and teacher) you will be able to use AutoFilter to see the information you want.