Delete rows so that student only appears once on sheet

[Tyso]

Hi everyone

I use this code to create sheets for courses but the student appears more than once - see attached Sample (Before sheet).
How can the code be changed so that the student only appears once on the sheet? - see attached Sample (After sheet).

Any assistance will be much appreciated

Please Login or Register  to view this content.

[AB33]

Excel has a built-in function called Remove duplicate.

Please Login or Register  to view this content.

[Tyso]

Hi AB33

Thank you very much for solving my problem!