Bonjour
L'enregistreur marche parfaitement
Sub Macro1()
Sheets("Feuil1").Activate
Range("D2").FormulaR1C1 = "=LEN(RC[-1])-LEN(SUBSTITUTE(RC[-1],""/"",""""))"
Range("E2").FormulaR1C1 = _
"=IF(OR(LEFT(RC[-2],2)=""HQ"",MID(RC[-2],3,3)=""/11""),VLOOKUP(LEFT(RC3,5),C3:C15,12,0),VLOOKUP(LEFT(RC3,4),C3:C15,12,0))"
Range("F2").FormulaR1C1 = _
"=IF(AND(RC4=2,RC11=""bottom""),"""",IF(OR(LEFT(RC[-3],2)=""HQ"",MID(RC[-3],3,3)=""/11""),IF(OR(VLOOKUP(LEFT(RC3,8),C3:C24,12,0)=RC[-1],RC[-1]=""""),"""",VLOOKUP(LEFT(RC3,8),C3:C24,12,0)),IF(OR(VLOOKUP(LEFT(RC3,6),C3:C24,12,0)=RC[-1],RC[-1]=""""),"""",VLOOKUP(LEFT(RC3,6),C3:C24,12,0))))"
Range("G2").FormulaR1C1 = _
"=IF(AND(RC4=3,RC11=""bottom""),"""",IF(OR(LEFT(RC[-4],2)=""HQ"",MID(RC[-4],3,3)=""/11""),IF(OR(VLOOKUP(LEFT(RC3,11),C3:C24,12,0)=RC[-1],RC[-1]=""""),"""",VLOOKUP(LEFT(RC3,11),C3:C24,12,0)),IF(OR(VLOOKUP(LEFT(RC3,8),C3:C24,12,0)=RC[-1],RC[-1]=""""),"""",VLOOKUP(LEFT(RC3,8),C3:C24,12,0))))"
End Sub
Cordialement