Download the featured file and code here: https://www.bluepecantraining.com/wp-content/uploads/2021/02/Fill-Blank-Cells.xlsx

Here's the VBA code:

Sub FillDownBlanks()
Dim UserSelection As Range
Dim CellWithinSelection As Range
Set UserSelection = Selection
For Each CellWithinSelection In UserSelection
If CellWithinSelection = "" Then
CellWithinSelection.FillDown
End If
Next CellWithinSelection
End Sub

Power Query add-in: https://www.microsoft.com/en-gb/download/details.aspx?id=39379

In this video I demonstrate how to fill blank cells with the value stored in the cell above in Excel. I demonstrate four methods:

1) Formula method
2) Power Query method
3) VBA macro method
4) PivotTable method

This video will answer the following queries:
Fill down from cell above in Excel
Excel formula to fill cell below with cell above until value changes
How to fill blank cells with value above in Excel
How to fill blank cells with value above in Excel VBA
Excel copy data into next empty cell
Macro copy and paste in next blank cell
Excel macro to add data to next empty row
Fill blank cells with value above VBA
Excel copy values to empty cells below
------------------------