I have a macro that copies/pastes to next row-below, but what I am trying to accomplish is that in the event some data was deleted above last row pasted...it would know to post in that blank row above, then continue as normal pasting below.
Sub Data()
'Modified 12/5/2018 3:21:41 PM EST
Application.ScreenUpdating = False
Dim Lastrow As Long
Lastrow = Cells(Rows.Count, "C").End(xlUp).Row + 1
If Lastrow < 12 Then Lastrow = 12
Range("C6:G6").Copy
Cells(Lastrow, "C").PasteSpecial xlValues
Application.CutCopyMode = False
Application.ScreenUpdating = True
End Sub
Sub Data()
'Modified 12/5/2018 3:21:41 PM EST
Application.ScreenUpdating = False
Dim Lastrow As Long
Lastrow = Cells(Rows.Count, "C").End(xlUp).Row + 1
If Lastrow < 12 Then Lastrow = 12
Range("C6:G6").Copy
Cells(Lastrow, "C").PasteSpecial xlValues
Application.CutCopyMode = False
Application.ScreenUpdating = True
End Sub