How can excel copy down heading from same column

[omairhe]

Hello all,

What is the best way to do this. There are numerous headings in my column E. I would like to copy down each heading up til value found in adjacent cell on the left.



Will appreciate a nice macro pls.

 

[JLGWhiz]

Hello all,

What is the best way to do this. There are numerous headings in my column E. I would like to copy down each heading up til value found in adjacent cell on the left.



Will appreciate a nice macro pls.

See if this will work.

Sub copystuff()
Dim sh As Worksheet, lr As Long
Set sh = Sheets(1) 'Edit sheet name
lr = sh.Cells(Rows.Count, 4).End(xlUp).Row
    For i = lr To 1 Step -1
        With sh
            sz = i - .Cells(i, 5).End(xlUp).Row
            .Cells(i, 5).End(xlUp)(2).Resize(sz, 1) = .Cells(i, 5).End(xlUp).Value
            i = .Cells(i, 5).End(xlUp).Row
        End With
    Next
End Sub