Sub boucledecopie()
'
' boucledecopie Macro
' Macro enregistrée le 23/02/2012 par BBDOC
'
'
Range("G9").Select
Application.CutCopyMode = False
Selection.Copy
Range("G10").Select
ActiveSheet.Paste
Range("E10:H10").Select
Application.CutCopyMode = False
Range("E10:H10").Cut Destination:=Range("E9:H9")
Rows("10:10").Select
Selection.Delete Shift:=xlUp
End Sub