|
- Sub 填充()
- Set d = CreateObject("scripting.dictionary")
- Arr = Sheets("引用").[a1].CurrentRegion
- Dim pj(67 To 73) 'BO到BU列超标的元素名
- For i = 67 To 73
- pj(i) = Split(Arr(1, i), "(")(0)
- Next
- For i = 3 To UBound(Arr)
- x = Arr(i, 2)
- If Arr(i, 1) Like "铅*" And x <> "" Then
- d(x) = d(x) & ""
- For j = 67 To 73 'BO到BU列
- y = Arr(i, j)
- If InStr("一级二级三级", y) > 0 Or y = "四级品以下" Then
- If d(x) = "" Then
- d(x) = pj(j)
- ElseIf InStr(d(x), pj(j)) = 0 Then
- d(x) = d(x) & "," & pj(j)
- End If
- End If
- Next
- End If
- Next
- With ActiveSheet
- r = 22 '显示位置,自行调节
- .Cells(r, 2).Resize(d.Count, 1) = Application.Transpose(d.keys) '去重的公司名
- .Cells(r, "I").Resize(d.Count, 1) = Application.Transpose(d.items) '超标元素
- End With
- End Sub
复制代码 |
评分
-
查看全部评分
|