try this macro, next change C1 and again try
![]()
Sub test() Dim ddate As Date, r As Range, cfind As Range ddate = CDate(Range("C1")) Set cfind = Cells.Find(what:=ddate, lookat:=xlWhole, after:=Range("C1")) Set r = Range(Range("c4"), Range("c4").End(xlDown)) r.Copy cfind.Offset(1, 0) MsgBox "macro done" End Sub
Bookmarks