Copy specific range from one sheet and paste to next available row of different sheet

Hello koklok,

This macro will paste only the values from the Range("A3:H6") on "Step 1" to the next empty row on "Step 2". Copy this code and paste it into a VBA module in your project.

Sub CopyData()

    Worksheets("Step 1").Range("A3:H6").Copy
    Worksheets("Step 2").Cells(Rows.Count, "A").End(xlUp).PasteSpecial Paste:=xlPasteValues
    
End Sub

Sincerely,
Leith Ross