Interpolation in Excel/VBA

Is there a way to fill in the blank cells by interpolating between the first non-blank cells above and below?

You can see what I mean exactly in the attached Excel sheet.

AttachmentSize
Workbook1.xlsx26.02 KB