Sub Copie()
Dim Derlig&, Maval As Range
Derlig = Range("H" & Rows.Count).End(xlUp).Row
If Derlig < 8 Then Derlig = 8
Range("H2:H" & Derlig).Resize(, 6).ClearContents
For i = Range("A" & Rows.Count).End(xlUp).Row To 2 Step -1
If Range("A" & i) = "" Then
Range("H" & i).Resize(, 6).Value = Maval.Value
Else
Range("H" & i).Resize(, 6).Value = Range("A" & i).Resize(, 6).Value
Set Maval = Range("A" & i).Resize(, 6)
End If
Next i
End Sub