Sub test()
Dim Arr, ND As Date, Brr, i&, j%
ND = Sheets(2).[b2]
Arr = Sheets(1).[a1].CurrentRegion
ReDim Brr(1 To UBound(Arr), 1 To 10)
For i = 3 To UBound(Arr)
If Arr(i, 7) = ND Then
n = n + 1
For j = 1 To 6: Brr(n, j) = Arr(i, j): Next
For j = 7 To 10: Brr(n, j) = Arr(i, j + 5): Next
End If
Next
Sheets(2).[a1].CurrentRegion.Offset(3, 0) = ""
Sheets(2).[a4].Resize(n, 10) = Brr
End Sub