One interpretation on your post, and a possible way to automate your
underlying intents is illustrated in this sample:

http://www.savefile.com/files/1035931
Extract failure list fr x n past grades history fr y.xls

In sheet: z,
To "filter" the failure list from sheet: x, I used the underlying papers'
marks (ie numbers) rather than alphabetic grades, and relied on looking up
unique student IDs (rather than names) to match/extract their historical
records from the masterlist in sheet: y

-----
Here's the set-up descript

Assume that sheet:
x = Listing for latest paper3 (marks in col C, from row2 down)
y = MasterList for the subject (Papers 1 to 3)
[Student IDs and names are assumed in cols A and B,
from row2 down in both sheets x and y]

In a new sheet: z,

In A2:
=IF(x!C2="","",IF(x!C2<55,ROW(),""))
Marks < 55 is the assumed failure criteria.
Leave A1 blank

In B2:
=IF(ROWS($1:1)COUNT($A:$A),"",INDEX(x!A:A,SMALL($ A:$A,ROWS($1:1))))
Copy B2 to C2, fill down to cover the max data extent expected in sheet: x.
Cols B and C will extract the list of IDs & names of students who "failed" in
x (latest paper3), ie those who scored less than 55 marks, with all lines
neatly bunched at the top.

Then in D2:
=IF(ISNA(MATCH($B2,y!$A:$A,0)),"",INDEX(y!C:C,MATC H($B2,y!$A:$A,0)))
Copy D2 to I2, fill down to populate. Cols D to I will extract the past
grades history results for all these failed students from the masterlist in
sheet: y.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Kathy Houtami" wrote:
Hi All,

Is it possible to extract the filtered result after using the
AutoFilter and use this list to be the filter criteria on another
worksheet.

So for example:
on the first worksheet - filter for all failed (grade <= D+) students
on one paper
on the next worksheet - get the filtered list on the 1st worksheet and
automatically use this list to custom filter the next list, so it will
display all the failed students past grades history


Can this be done?

Cheers
Kathy