Bonjour le forum, bonjour Pauline,
Un essai :
Sub test()
Dim derligliste, derliganalyse, lig As Integer
derlig = Range("A1").End(xlDown).Row
For Each cell In Sheets("Liste").Range("C2:C" & derlig)
lig = cell.Row
If cell.Value = "Donnée 2C" Then
Sheets("Liste").Range("A" & lig & ", C" & lig & ", D" & lig).Select
Selection.Copy
Sheets("Analyse").Activate
derliganalyse = Range("A1").End(xlDown).Row
Range("A" & derliganalyse + 1).Select
Selection.PasteSpecial Paste:=xlPasteValues
Sheets("Liste").Activate
End If
Next cell
Sheets("Analyse").Activate
End Sub