|
点击工种按钮后执行代码
Sub Macro3()
Dim arr, brr, crr, d, i&, j%, k%, zf$
Set d = CreateObject("scripting.dictionary")
arr = Range("a2").CurrentRegion
For i = 3 To UBound(arr)
zf = arr(i, 8) & "," & arr(i, 9) & "," & arr(i, 1)
d(zf) = arr(i, 7)
Next
For k = 1 To 2
brr = Sheets(k).Range("a2:ak" & Sheets(k).Range("a65536").End(xlUp).Row)
For i = 3 To UBound(brr)
For j = 4 To UBound(brr, 2)
zf = brr(i, 2) & "," & brr(i, 3) & "," & brr(1, j)
brr(i, j) = d(zf)
Next
Next
Sheets(k).Range("a2").Resize(UBound(brr), UBound(brr, 2)) = brr
Next
End Sub
|
|