Option Explicit
Sub boucle()
Dim i As Integer, j As Integer, k As Integer
i = 1
j = 1
k = 1
With Sheets("f1")
Do While .Range("A" & i).Value <> ""
If .Range("A" & i).Offset(0, 1).Value = "oui" Then
Sheets("f2").Cells(j, k).Value = .Range("A" & i).Value
j = IIf(j < 10, j + 1, 1)
k = IIf(j = 1, k + 1, k)
End If
i = i + 1
Loop
End With
End Sub