Code:
Can anyone help me with a formula to solve this please??
IMHO, a macro might be easier to work with as with a formula you would have to use a column other than A and then copy and paste.
This macro will look for the last row of column B and then apply the results from column A from the bottom up.
Code:
Sub FillRangeFromAbove()
Dim LR As Long
Dim i As Long
LR = Range("B" & Rows.Count).End(xlUp).Row
For i = LR To 2 Step -1
If Range("A" & i - 1).Value = "" Then
Range("A" & i - 1).Value = Range("A" & i).Value
End If
Next i
End Sub
If you are not familiar with macros, this might help...
http://www.rondebruin.nl/win/code.htm