Bonjour,
Sub Macro1()
Dim sh1, sh2, j As Integer, n As Long
Set sh1 = Sheets("Données")
Set sh2 = Sheets("MoisCourant")
j = Day(sh1.Range("C1"))
n = Application.Match(sh1.Range("C1"), sh2.Range("A:A"), 0) + 2
sh2.Range(sh2.Cells(n, 1), sh2.Cells(n, 28)).Value = sh1.Range(sh1.Cells(30, 2), sh1.Cells(30, 29)).Value
End Sub