1个回答
展开全部
Sub s()
arr = [a1].CurrentRegion
brr = [a11].CurrentRegion
Set d = CreateObject("scripting.dictionary")
For i = 2 To UBound(brr)
d(brr(i, 1) & brr(i, 2)) = i
Next
For i = 2 To UBound(arr)
t = arr(i, 1) & arr(i, 2)
If d.Exists(t) Then
brr(d(t), 3) = brr(d(t), 3) + arr(i, 3)
brr(d(t), 4) = brr(d(t), 4) + arr(i, 4)
End If
Next
[a11].Resize(UBound(brr), UBound(brr, 2)) = brr
End Sub
来自:求助得到的回答
本回答被提问者和网友采纳
已赞过
已踩过<
评论
收起
你对这个回答的评价是?
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询