|
本帖最后由 dsmch 于 2014-5-6 15:18 编辑
按楼主要求完善一下代码- Sub Macro1()
- Dim arr, brr(1 To 60000, 1 To 9), i%, j&, s&, zf$
- w = Array("张三", "李四", "王五", "郑六")
- For i = 2 To Sheets.Count
- zf = Sheets(i).Name
- arr = Sheets(i).Range("a1").CurrentRegion
- For j = 3 To UBound(arr)-1
- If arr(j, 9) < 0.75 Then
- s = s + 1
- brr(s, 1) = zf
- brr(s, 2) = arr(j, 1)
- brr(s, 3) = arr(j, 2)
- brr(s, 4) = arr(j, 3)
- brr(s, 5) = arr(j, 8)
- brr(s, 6) = arr(j, 6)
- brr(s, 7) = IIf(arr(j, 10) = "", "慢,需加强管理", arr(j, 10))
- brr(s, 8) = arr(j, 9)
- brr(s, 9) = w(i - 2)
- End If
- Next
- Next
- Sheet1.Activate
- Range("a3").Resize(s, UBound(brr, 2)) = brr
- End Sub
复制代码 |
|