' Données
select1 = Range("C5:C" & CDbl(Range("A4")) + 5)
select2 = Range("B5:B" & CDbl(Range("A4")) + 5)
a = CDbl(Range("A4")) 'nombre d'employés
b = a + 11 ' Ligne FSC 1
c = b + 3 ' Ligne FSC 4
d = Cells(b, 2) ' Case FSC 1
Range(Cells(b, 3), Cells(c, 17)).FormulaLocal = "=SI(ESTNA(EQUIV(d;select1;0));"""";INDEX(select2;EQUIV(d;select1;0)))"
Range(Cells(b, 3), Cells(c, 17)) = Range(Cells(b, 3), Cells(c, 17)).Value