|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
Sub cs()
Application.ScreenUpdating = False
Dim arr, brr, arr1(1 To 100000, 1 To 8), arr2(1 To 10000, 1 To 4)
arr = Sheets("销售明细").UsedRange
brr = Sheets("回款明细").UsedRange
Sheets("查询表").Range("a9:n10000").Clear
Dim i, x, y, k
i = 8
k = 8
For x = 1 To UBound(arr)
arr1(x, 1) = Array(arr(x, 1), arr(x, 4), arr(x, 5), arr(x, 6), arr(x, 10), arr(x, 7), arr(x, 11), arr(x, 9))
If arr(x, 2) Like Sheets("查询表").Range("c4") And arr(x, 1) >= Sheets("查询表").Range("k4") And arr(x, 1) <= Sheets("查询表").Range("n4") Then
i = i + 1
Sheets("查询表").Range("a" & i) = i - 8
Sheets("查询表").Range("b" & i).Resize(1, 8) = arr1(x, 1)
End If
Next
For y = 1 To UBound(brr)
arr2(y, 1) = Array(brr(y, 1), brr(y, 7), brr(y, 8), brr(y, 9))
If brr(y, 3) Like Sheets("查询表").Range("c4") And brr(y, 1) >= Sheets("查询表").Range("k4") And brr(y, 1) <= Sheets("查询表").Range("n4") Then
k = k + 1
Sheets("查询表").Range("j" & k).Resize(1, 4) = arr2(y, 1)
End If
Next
Application.ScreenUpdating = True
MsgBox "ok"
End Sub
|
评分
-
1
查看全部评分
-
|