|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
- Sub 对比()
- Dim arr, brr, d, i, j, r, n, d1
- Set d = CreateObject("scripting.dictionary")
- Set d1 = CreateObject("scripting.dictionary")
- arr = Sheet1.UsedRange '表一
- brr = Sheet2.UsedRange '表二
- For i = 2 To UBound(brr)
- sa = brr(i, 1)
- If Not d.exists(sa) Then
- d(sa) = i '第一次出现的行号
- End If
- Next
- ReDim crr(1 To 10000, 1 To 100)
- For j = 2 To UBound(arr)
- sb = arr(j, 1)
- ii = d(sb)
- If ii > 0 Then
- d1(sb) = j
- Else
- n = n + 1
- For i = 1 To UBound(arr, 2)
- crr(n, i) = arr(j, i)
- Next
- End If
- Next
- Sheet4.[a:a,b:b,d:d,e:e].NumberFormatLocal = "@"
- Sheet4.[f:f,g:g,h:h,i:i].NumberFormatLocal = "yyyy-m-d"
- Sheet4.[a6].Resize(n, 20) = crr
- End Sub
复制代码 |
|