View Single Post
 
Old 05-03-2016, 03:31 PM
jeffreybrown jeffreybrown is offline Windows Vista Office 2007
Expert
 
Join Date: Apr 2016
Posts: 673
jeffreybrown has a spectacular aura aboutjeffreybrown has a spectacular aura about
Default

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
Reply With Quote