我想把下面代码放到菜单上,任何工作表都能运行,从表2中符合表1三个条件提取到表1,谢谢!
Sub 统计()
Dim i, d
Set d = CreateObject("Scripting.Dictionary")
With Sheet2
For i = 3 To .[a65536].End(3).Row
d(.Range("a" & i).Value & .Range("b" & i).Value & .Range("c" & i).Value) = Array(.Range("d" & i), .Range("e" & i))
Next i
End With
For i = 6 To [c65536].End(3).Row
Range("d" & i & ":e" & i) = d(Range("az" & i).Value & Range("c" & i).Value & Range("ba" & i).Value)
Next
End Sub