Bonjour,
voici pour la dernière version,
Sub Transfert_Ligne()
Set oSh1 = ActiveSheet
Set oSh2 = Sheets(" Pesées Lot 2 et 3")
Set Target = ActiveCell
rw1 = Target.Row
rw2 = oSh2.Cells(Rows.Count, 2).End(xlUp).Row
nbBrebis = Application.CountA(oSh1.Range("F" & rw1 & ":H" & rw1))
For i = 1 To nbBrebis
With oSh2
If oSh1.Cells(rw1, 5 + i).Borders(xlDiagonalDown).LineStyle = xlNone Then
.Cells(rw2 + i, 1) = oSh1.Cells(rw1, "I") 'No MB
.Cells(rw2 + i, 2) = oSh1.Cells(rw1, "A") 'No Mère
.Cells(rw2 + i, 3) = oSh1.Cells(rw1, "B") 'Nom Mère
.Cells(rw2 + i, 4) = oSh1.Cells(rw1, 5 + i) 'sexe
.Cells(rw2 + i, 6) = oSh1.Cells(rw1, "E") 'Date MB
End If
End With
Next
oSh2.Activate
End Sub