hi Stryda
Ot add value to top of the list
![]()
Sub ptest() With Worksheets("1 Database") .Rows("5:5").Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove .Range("C5").Value = Date .Range("D5").Value = ActiveSheet.Range("E8").Value .Range("E5").Value = ActiveSheet.Range("E13").Value .Range("F5").Value = ActiveSheet.Range("E18").Value End With With ActiveSheet .Range("E8").ClearContents .Range("E13").ClearContents .Range("E18").ClearContents End With End Sub
Bookmarks