Hi Max

I have tried your solution, unfortunately not quite suited for my
problem.

What I have is 2 worksheets on the same workbook, both worksheets has
exactly the same data.

It has ID column (number), Name, Grade (but I have also added a
numeric column to convert the grade so I can easily do filter on this,
and once the result is produced this numeric column will be hidden
before it goes to print), papers (which will list any papers has been
taken by each student - like your y worksheet, but rather then listing
the papers across, it is all listed down).

ID Name Marks Grade Paper
1001 Nam1 68 C P1
1002 Nam2 78 B P1
1003 Nam3 42 D P1
1004 Nam4 86 A P1
1005 Nam5 65 C P1
1006 Nam6 66 C P1
1001 Nam1 55 C P2
1002 Nam2 60 C P2
1003 Nam3 58 C P2
1004 Nam4 76 B P2
1005 Nam5 43 D P2
1006 Nam6 67 C P2
1001 Nam1 39 E P3
1002 Nam2 89 A P3
1003 Nam3 44 D P3
1004 Nam4 73 B P3
1005 Nam5 40 D P3
1006 Nam6 52 D+ P3
1001 Nam1 68 C P5
1002 Nam2 78 B P8
1004 Nam4 73 B P9
.. . . . .
.. . . . .
.. . . . .

One the first worksheet I have put AutoFilter on the column headers,
so I can filter by Paper and custom filter on the Marks column to find
all failed students for one paper.

And I would like sheet2 to automatically pick up the ID numbers from
the filtered sheet1, and filter sheet2 list to display only those ID
listed on sheet1 and sort by the Paper.

Cheers
Kathy


On Sep 10, 2:35 pm, Kathy Houtami wrote:
Thank you Max, I will give your suggestion ago and update you

On Sep 7, 2:48 pm, Max wrote:



Typo in this line:

Copy B2 to C2, fill down to cover the max data extent expected in sheet: x.

It should read as:
Copy B2 to C2. Select A2:C2, fill down to cover the max data extent expected
in sheet: x.

--
Max
Singaporehttp://savefile.com/projects/236895
xdemechanik
---- Hide quoted text -

- Show quoted text -