Macro to fill in blanks with data from previous row

Hello, I have a file with 8 columns, the first 5 of which will together be blank for some rows. I'm looking for a macro that takes the values from the preceding row and fills in the blanks. Occasionally there will be multiple consecutive rows of blanks that all need data populated from the most recent previous row with data in those 5 columns.

My attachment has a before on the left and an after on the right, with the data to be copied in green and the copied data in yellow. Ultimately though I'm just looking for the data to be populated in place without color formatting; the attachment is just formatted as such to illustrate the problem and the desired solution.

Thank you for any help you can provide!

Matt

According to your attachment a VBA demonstration for starters :

PHP Code: 

Sub Demo1()
          Dim Ra As Range
   With [A1].CurrentRegion
     If Application.CountBlank(.Columns(1)) Then
     For Each Ra In .Columns(1).SpecialCells(4).Areas
              Ra.Resize(, 5) = Ra(0).Resize(, 5).Value
     Next
     End If
   End With
End Sub 


► Do you like it ? ► ► So thanks to click on bottom left star icon « ★ Add Reputation » ! ◄ ◄

Works perfectly, thank you!