|
- Sub test()
- Dim arr, brr(), k As Integer, i As Byte, str As String, date1, date2, n As Integer
- arr = Sheet9.Range("A2").CurrentRegion
- str = Sheet3.Range("B2")
- date1 = Sheet3.Range("D2")
- date2 = Sheet3.Range("E2")
- For k = 3 To UBound(arr)
- If arr(k, 1) = str And arr(k, 7) >= date1 And arr(k, 7) <= date2 Then
- n = n + 1
- ReDim Preserve brr(1 To 15, 1 To n)
- For i = 1 To 7
- brr(i, n) = arr(k, i)
- Next i
- brr(8, n) = arr(k, 12)
- brr(12, n) = arr(k, 8)
- brr(13, n) = arr(k, 9)
- End If
- Next k
- Sheet3.Range("a4:m200").ClearContents
- Sheet3.Range("a4").Resize(n, 15) = Application.WorksheetFunction.Transpose(brr)
- End Sub
复制代码 |
|