Hi all,
I started a code but I am not too sure how to finish it and I am stuck.
Sub Copy_Paste_Loop()
Dim PrevPupilCode As String
Dim currentline As Integer
Dim currentPupilcode As String
Dim Sht As Worksheet
currentline = 2
PrevPupilCode = "nothing"
Do...