|
发表于 2012-10-5 02:25
|
显示全部楼层
本楼为最佳答案
Sub 数据处理6() '提取指定营业部的涉及的股票
Dim arr, i, s
Dim oDic As Object
With Sheets("数据源")
For i = 2 To 21
s = s & "," & .Range("j" & i)
Next
arr = .Range("a2:f" & .[b65536].End(xlUp).Row)
End With
Set oDic = CreateObject("scripting.dictionary")
For i = 1 To UBound(arr)
If InStr(s, arr(i, 6)) > 0 And arr(i, 2) = "一" Then oDic(arr(i, 4)) = ""
Next
With Sheet3
.[C1].Value = "股票代码"
.[C2].Resize(oDic.Count, 1) = Application.Transpose(oDic.keys)
.Select
End With
Set oDic = Nothing
End Sub
|
|