|
发表于 2014-2-27 13:41
|
显示全部楼层
本楼为最佳答案
a8和要求不一致,是否有误?- Sub Macro1()
- Dim arr, brr, zf$, i&
- arr = Range("a1").CurrentRegion
- ReDim brr(1 To UBound(arr) - 1, 1 To 1)
- zf = "人事行政部,财务部,资讯部,商务工程部,培训企划部"
- For i = 2 To UBound(arr)
- If InStr(zf, arr(i, 1)) Then
- brr(i - 1, 1) = "大区"
- If InStr(arr(i, 4), "租金") > 0 Or InStr(arr(i, 4), "物业") > 0 Then brr(i - 1, 1) = arr(i, 3)
- Else
- brr(i - 1, 1) = arr(i, 3)
- End If
- Next
- Range("b2").Resize(UBound(brr)) = brr
- End Sub
复制代码 |
|