Private Sub CommandButton1_Click()
Dim r&, f&, crr, err
a = Cells(3, 3).Value
c = Cells(1, 3): k = Cells(1, 6)
crr = Worksheets(a).Range("c5:bl" & Worksheets(a).Cells(Rows.Count, 2).End(xlUp).Row)
[e7:j60].ClearContents
err = Range("d7:j60")
For r = 1 To UBound(crr, 2)
If crr(1, r) >= c And crr(1, r) <= k Then
For f = 3 To UBound(crr)
n = n + 1
err(n, 2) = crr(f, r - 1)
err(n, 7) = crr(f, r)
Next
End If
Next
Worksheets("sheet1").Range("e7").Resize(UBound(err), 1) = Application.Index(err, 0, 2)
Worksheets("sheet1").Range("j7").Resize(UBound(err), 1) = Application.Index(err, 0, 7)
End Sub