Sub lkjm()
Set rec = Sheets("Recap J")
Set det = Sheets("destinataires")
Do
If IsNumeric(rec.Range("u65536").End(xlUp).Offset(i, 0)) Then
det.Range("a1") = rec.Range("u65536").End(xlUp).Offset(i - 1, -2)
det.Range("a2") = rec.Range("u65536").End(xlUp).Offset(i, -2)
det.Range("b1") = rec.Range("u65536").End(xlUp).Offset(i - 1, 0)
det.Range("b2") = rec.Range("u65536").End(xlUp).Offset(i, 0)
Exit Sub
End If
i = i - 1
Loop
End Sub