- Sub Macro1()
- Dim arr, brr(1 To 60000, 1 To 6), w
- Dim i%, j&, k%, s&, rq1#, rq2#, kh$, dq$
- w = Array(1, 2, 3, 4, 5, 6) '要统计的工作表名称
- rq1 = [c3]: rq2 = [c4]
- For i = 0 To UBound(w)
- If Sheets("" & w(i)).[b24] <> "" Then
- With Sheets("" & w(i))
- kh = .[d4] '客户
- dq = .[d5] '客户地区
- arr = .Range("b24:e" & .Range("b65536").End(xlUp).Row)
- End With
- For j = 1 To UBound(arr)
- If arr(j, 1) >= rq1 And arr(j, 1) <= rq2 Then
- s = s + 1
- For k = 1 To UBound(arr, 2)
- brr(s, 1) = kh
- brr(s, 2) = dq
- brr(s, k + 2) = arr(j, k)
- Next
- End If
- Next
- End If
- Next
- Range("b6").Resize(s, 6) = brr
- End Sub
复制代码 |