Macro to Match Criteria in Columns and Output to New Columns

Hi

I am re-posting a problem I asked previously but have run into some issues (and the original problem has changed very slightly) and hoping Mumps1 or jindon (who originally helped me) or anyone else can help?


I am trying to copy across names of (3 groups of) students who (only) have a Code C next to their name for BOTH subjects (math and English) to new columns. The code is creating the 3 new lists of names fine but is not copying the names across correctly. For e.g. some students have a code C for math and U for English but are getting copied across. And some students are getting copied across who may exist for math but are not even in the English list(!)


I've attached the sheet again. Could somebody help and sorry for the hassle of the re-post.


Many thanks in advance for your help.