getting specific data from one page to another

[John A]

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/com...0-8e988a52f83e&dg=microsoft.public.excel.misc

 

[Don Guillett]

data>filter>autofilter>>>>>

 

[Mike]

You could filter the data on your main sheet. Then either print the filter
data or copy and paste the a new sheet would be the fastest way.

 

[Huber57]

John,

I agree that filtering is the best way to go. But if you want to have a
separate report for each teacher on a different tab, you could write an Sql
query to pull the data you want to a particular worksheet.

SELECT `Sheet1$`.Student, `Sheet1$`.`Test Score`, `Sheet1$`.Teacher
FROM `C:\Documents and Settings\User\Desktop\Excel
Class\Book1.xlsx`.`Sheet1$` `Sheet1$`
WHERE (`Sheet1$`.Teacher='JA1')

This would allow you to enter all the data on Sheet1 and then refresh all of
the queries at once and then hit print to print all of the worksheets. You
could then do analysis on each separate worksheet (avg, std dev, mean, etc)

Hope that helps.