Bonjour,
Une proposition à étudier.
Cdlt.
Option Explicit
Public Sub Saisie()
Dim ws As Worksheet, ws2 As Worksheet
Dim tbl, tbl2
Dim rw As Long, I As Long, k As Long
Application.ScreenUpdating = False
Set ws = Worksheets("Grille")
Set ws2 = Worksheets("Compilation")
rw = ws2.Cells(Rows.Count, "E").End(xlUp).Row + 1
tbl = Array("D6", "G6", "E9", "G13", "G15", "G17", "G19", "G21", "G23", "G25")
tbl2 = Array("E", "G", "P", "I", "J", "K", "L", "M", "N", "O")
For I = LBound(tbl) To UBound(tbl)
With ws2
k = k + 1
.Range(tbl2(I) & rw).Value = ws.Range(tbl(I)).Value
End With
Next I
Range("D6,G6,E9,G13,G15,G17,G19,G21,G23,G25").ClearContents
End Sub