I am trying to create a module/procedure code which would let me fill
missing fields in Excel based on the values that are above and below it.
(That is realy confusing)

As an example I have 6 cells one of them has variable? "Close" and the other

I need to write a loop in Excel where empty fields that are above or below
variable "Close" would show "Close" and variable "New" would fill empty
space that are below "New" cell.

I believe that it would start something like Sub RefButton()

If cell = "Close" empty cell above is also "Close" and empty cell below =


If cell is "New" empty cell below would also be= "New".

Would anyone know of a cure to my problem?