|
本帖最后由 zjdh 于 2022-12-18 11:00 编辑
Sub TEST()
Set dic = CreateObject("scripting.dictionary")
arr = Sheets("数据表").Range("P1").CurrentRegion
For i = 2 To UBound(arr)
dic(arr(i, 2)) = Array(arr(i, 4), arr(i, 5), arr(i, 6), "", arr(i, 3))
Next
brr = Sheets("查询表").Range("D1:I" & Sheets("查询表").Range("D65536").End(3).Row)
For i = 2 To UBound(brr)
crr = dic(brr(i, 1))
For J = 0 To UBound(crr)
brr(i, J + 2) = crr(J)
Next: Next
Sheets("查询表").Range("D1").Resize(UBound(brr), 6) = brr
MsgBox "查询完成!"
End Sub
|
|