|
发表于 2014-4-7 21:04
|
显示全部楼层
本楼为最佳答案
- Sub Macro1()
- Dim arr, brr, crr, d, i&
- Set d = CreateObject("scripting.dictionary")
- arr = Range("a3:ah" & Range("a65536").End(xlUp).Row)
- brr = Sheets("条件").[b3:b9]
- ReDim crr(1 To UBound(arr), 1 To 1)
- For i = 1 To UBound(brr)
- d(brr(i, 1) & "村") = i
- Next
- For i = 1 To UBound(arr)
- crr(i, 1) = d(arr(i, 3))
- Next
- Range("ai3").Resize(UBound(crr)) = crr
- Range("a3").Resize(UBound(arr), UBound(arr, 2) + 1).Sort Key1:=Range("AI3"), Order1:=xlAscending, Header:=xlGuess
- [ai:ai].ClearContents
- End Sub
复制代码 |
|