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