Private Sub CommandButton1_Click()
num = InputBox(" Quel numéro de feuille ?", "num")
If num = "" Then Exit Sub
ActiveSheet.Copy After:=Sheets(num)
Worksheets("récap").Select
With ActiveWorkbook.Worksheets("récap").Range("A1:A50")
Set c = ActiveSheet.Columns(1).Cells.Find(What:=num)
If Not c Is Nothing Then
c.Select
c.Select:
ActiveCell.Offset(0, 9).Activate
ActiveCell.Formula = ActiveCell + Sheets("fiche").Range("H43").Value
End If
End With
Worksheets("récap").Select
With ActiveWorkbook.Worksheets("récap").Range("A1:A50")
Set c = ActiveSheet.Columns(1).Cells.Find(What:=num)
If Not c Is Nothing Then
c.Select
c.Select:
ActiveCell.Offset(0, 4).Activate
ActiveCell.Formula = ActiveCell + 1
End If
End With
End Sub