|
在sheet3中下列代码:- Sub tt()
- arr = Sheet1.[a1].CurrentRegion
- brr = Sheet2.[a1].CurrentRegion
- Set d = CreateObject("scripting.dictionary")
- Set d1 = CreateObject("scripting.dictionary")
- Set d2 = CreateObject("scripting.dictionary")
- For i = 2 To UBound(arr)
- xm = Trim(arr(i, 4))
- If Len(xm) > 0 Then
- d(xm) = ""
- d1(xm) = arr(i, 17)
- End If
- Next
- For i = 2 To UBound(brr)
- xm = Trim(brr(i, 3))
- If Len(xm) > 0 Then
- d(xm) = ""
- d2(xm) = brr(i, 16)
- End If
- Next
- With Sheet3
- .UsedRange.Clear
- .[a1].Resize(1, 4) = Array("姓名", "表1数", "表2数", "差值")
- .[a2].Resize(d.Count, 1) = Application.Transpose(d.keys)
- crr = .[a1].CurrentRegion
- For i = 2 To UBound(crr)
- xm = crr(i, 1)
- crr(i, 2) = d1(xm): crr(i, 3) = d2(xm)
- crr(i, 4) = crr(i, 2) - crr(i, 3)
- Next
- .[a1].CurrentRegion = crr
- End With
- End Sub
复制代码 |
|