Automatically Filling Blanks

There is an Excel file that teaches how to perform the Automatically Filling Blanks operation.

Excel Template for Automatically Filling Blanks

This workbook automatically fills blank cells in a 26-row table by carrying down the value from the cell above, using VBA automation.

Hope it is useful.