Easy nuf..

In the first blank, type = and hit the down arrow.. creates the reference.

copy this cell, highlight the column..
Edit - Go to - Special - Blanks
Paste
Ta-Da!

"J.W. Aldridge" wrote:

I have a list of data in column B. Every few lines there is a blank.
In any instance of a blank cell, I want a code that will copy from the
value from the cell below and paste it into the blank cell.

The opposite of the fill/copy down code that would copy the last
value.

ex:
apples
cherries
blueberries

plums
mangos
kiwi

Desired result:

apples
cherries
blueberries
plums
plums
mangos
kiwi

The code found plums below the blank space so it copies and plugs that
value in.