Sub Dupliquer_Formule()
Sheets('TAMPON').Select
total = Range('f65536').End(xlUp).Row
Sheets('CONCURRENCE').Select
Range('B2').Select
Selection.AutoFill Destination:=Range('B2:E2'), Type:=xlFillDefault
Range('B2:E2').Select
Range('A2:E2').Select
Selection.AutoFill Destination:=Range('A2:E' & total), Type:=xlFillDefault
Range('A2:E13').Select
End Sub