Please help if you can.

I have a page in excel with test scores and their teacher intials next to
the student and scores. They are sorted by room number.

However I need a new page that would create a new list based on the teacher
initials.

See below

Student test score Teacher
Joe B - 86 - JA1
Sue B 92 TB2
Bob B 78 JA1

I want to make a new list on another page that pulls all of JA1's kids and
scores.

I know I can sort on the original page- but I want to be able to enter the
data and have forms ready to print without taking the time to sort.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc