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