|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
- Sub 按钮1_Click()
- Application.ScreenUpdating = False
- arr = [e1].CurrentRegion
- BRR = [a1].CurrentRegion
- For j = 2 To UBound(BRR)
- For i = 2 To UBound(arr)
- If Len(BRR(j, 1)) > 0 Then
- If Left(BRR(j, 1), 1) = "b" And Len(BRR(j, 1)) = 10 Then
- BRR(j, 2) = arr(i, 2)
- GoTo l1
- Else
- If InStr(BRR(j, 1), arr(i, 2)) > 0 Then
- BRR(j, 2) = arr(i, 2)
- GoTo l1
- End If
- End If
- End If
- Next i
- BRR(j, 2) = "其他"
- l1:
- Next j
- [a1].CurrentRegion = BRR
- Application.ScreenUpdating = True
- End Sub
复制代码 |
|