Slt Idma,
à tester.
Sub CopyPasteRanges()
Dim Cell As Range
With Sheets(1)
For Each Cell In .Range("A1:A" & .Cells(.Rows.Count, "A").End(xlUp).Row)
If Cell.Interior.Color = RGB(255, 238, 9) Then
Range("B" & Cell.Row - 1 & ":D" & Cell.Row - 1).Select
Selection.Copy
Range("B" & Cell.Row).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
Range("F" & Cell.Row - 1 & ":G" & Cell.Row - 1).Select
Selection.Copy
Range("F" & Cell.Row).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
Range("I" & Cell.Row - 1 & ":N" & Cell.Row - 1).Select
Selection.Copy
Range("I" & Cell.Row).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
End If
Next Cell
End With
End Sub