Sub Locc()
Application.ScreenUpdating = False
Dim z As Long, tmp As Variant, r As Long, KQ() As Variant, j As Long
Dim d1 As Long, d2 As Long, m As Long, y As Long, D
m = Sheet2.Range("B4"): y = Sheet2.Range("D4")
d1 = DateSerial(y, m, 1): d2 = Application.WorksheetFunction.EoMonth(d1, 0)
With Sheet1
z = .Range("G" & .Rows.Count).End(xlUp).Row
tmp = .Range("G6:AF" & z): z = UBound(tmp, 1)
ReDim KQ(1 To z, 1 To 13)
For r = 1 To z
D = tmp(r, 19)
If D <> Empty Then
D = CDate(D): D = CLng(D)
If d1 <= D And D <= d2 Then
j = j + 1
KQ(j, 1) = j: KQ(j, 2) = tmp(r, 3)
KQ(j, 3) = tmp(r, 2): KQ(j, 4) = tmp(r, 1)
KQ(j, 5) = tmp(r, 26): KQ(j, 6) = tmp(r, 4)
KQ(j, 7) = tmp(r, 17): KQ(j, 8) = tmp(r, 8)
KQ(j, 9) = CDate(tmp(r, 18)): KQ(j, 10) = CDate(tmp(r, 19))
KQ(j, 11) = tmp(r, 21): KQ(j, 12) = tmp(r, 24)
KQ(j, 13) = CDate(tmp(r, 23))
End If
End If
Next r
End With
If j Then
Sheet2.Range("A14").Resize(10000, 13).ClearContents
Sheet2.Range("A14").Resize(j, 13) = KQ
End If
Application.ScreenUpdating = True
End Sub