1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26
| Sub CopierSiS()
Dim Lig As Long
Dim Col As String
Dim NbrLig As Long
Dim NumLig As Long
Sheets("Ctr déterminé").Activate ' feuille de destination
Sheets("Ctr déterminé").Range("A3:M1000").Select
Selection.ClearContents
Col = "C" ' colonne de la donnée = "s"
NumLig = 2
With Sheets("Récapitulatif ") ' feuille source
NbrLig = .Cells(65536, Col).End(xlUp).Row
For Lig = 3 To NbrLig
If .Cells(Lig, Col).Value = "s" Then
.Cells(Lig, Col).EntireRow.Copy
NumLig = NumLig + 1
Cells(NumLig, 1).Select
ActiveSheet.Paste
End If
Next
End With
End Sub |
Partager