|
- Sub Macro1()
- Dim arr, brr, d, i&, j%, s&, zf$
- Set d = CreateObject("scripting.dictionary")
- ReDim brr(1 To 20000, 1 To 2)
- For j = 2 To Sheets.Count
- If Sheets(j).Name <> "月汇总" Then
- arr = Sheets(j).Range("b4").CurrentRegion
- For i = 2 To UBound(arr)
- zf = arr(i, 1) & "," & arr(i, 3)
- If Not d.exists(zf) Then
- s = s + 1
- d(zf) = ""
- brr(s, 1) = arr(i, 1)
- brr(s, 2) = arr(i, 3)
- End If
- Next
- End If
- Next
- [b5:c20000] = ""
- Range("b5").Resize(s, 2) = brr
- [b4].CurrentRegion.Sort Key1:=[b5], Key2:=[c5], Header:=xlGuess
- End Sub
复制代码 |
|