Copy/Paste Dynamic Range

Hi RS,

If i understood you query correctly then at first run your code will copy data only from C36:K63 range and will paste at C65:K92 however when will run this code again then code will copy data from C36:K92 and will always paste at starting from C65 and will overwrite the previous data.

The solution is, either you fix your copy range and create dynamic paste range or do not copy the previous day data just below the copy and paste on a different column.

In case your data input range will remain fix then you can use below code.

Sub Copy_Paste()
Dim ws As Worksheet: Set ws = ThisWorkbook.Sheets("Sheet1")
Dim LR As Long
LR = ws.Cells(Rows.Count, "C").End(xlUp).Row + 2
    Range("C36:K36").Copy Range("C" & LR)
    End Sub

Regards,
BS