Sub fill_codes()
'
' fill_codes Macro
'
'
i = 8
While Not Range("a" & i) = ""
Range("f" & i) = "=VLOOKUP(F$6,absences!$B:$C,2,FALSE)"
i = i + 2
Wend
i = 8
While Not Range("a" & i) = ""
Range("g" & i) = "=VLOOKUP(g$6,absences!$B:$C,2,FALSE)"
i = i + 2
Wend
i = 8
While Not Range("a" & i) = ""
Range("j" & i) = "=VLOOKUP(J$6,absences!$B:$C,2,FALSE)"
i = i + 2
Wend
End Sub