Bonsoir,
Une procédure (macro) pour faire ce que tu demandes :
Sub Transférer()
Dim tft(), n%, i%, h%
With Worksheets("Feuil1")
n = .Cells(.Rows.Count, 1).End(xlUp).Row
ReDim tft(1, n - 43)
For i = 43 To n
If .Cells(i, 1).Value <> "" Then
If IsNumeric(.Cells(i, 1).Value) Then
tft(0, h) = .Cells(i, 1).Value
If .Cells(i, 2) <> "" Then tft(1, h) = .Cells(i, 2).Value
h = h + 1
End If
End If
Next i
End With
ReDim Preserve tft(1, h - 1)
With Worksheets("Feuil2")
For i = 1 To h
.Cells(i, 1).Value = tft(0, i - 1)
.Cells(i, 2).Value = tft(1, i - 1)
Next i
End With
End Sub
Cordialement