Copy Cell contents to previous row.

[donlincolnmre2]

Hello

I'm looking for a macro that will copy cell contents of column E into Previous Row as it shows in this excel sheet in my google drive sheet.

" From bottom Up check for column E if it find blank cell then copy that row into above row. E.g in this sheet in column E cell e15 is blank so the marco shoud copy cell E16-L16 into E14 and E15, Same thing
in cell E10 since it’s a blank so the macro should copy E11-L11 in E9 and E10 and so on and so forth. "

https://docs.google.com/spreadsheets/d/1TusykH4FoqtuiiNZEGU5LCgsAadoFmzr3wJdC95xrxU/edit#gid=0


Any help would be greatly appreciated

Thanks.

 

[My Aswer Is This]

So why not:
If cell in column E is empty then delete that row.

 

[footoo]

Assuming no formulas in columns E:L that need to be retained :

With Range("E4:L" & Cells(Rows.Count, "E").End(3).Row)
    .SpecialCells(xlCellTypeBlanks).FormulaR1C1 = "=R[1]C"
    .Value = .Value
End With

 

[donlincolnmre2]

Hello Footoo

That worked great.

Thanks a lot!!