|
发表于 2015-3-30 19:56
|
显示全部楼层
本楼为最佳答案
- Sub 按钮1_Click()
- Dim ar, br(), x, l, r
- ar = Range("a4").CurrentRegion
- ReDim br(1 To UBound(ar), 1 To UBound(ar, 2))
- For x = 2 To UBound(ar)
- If Not Application.IsNA(ar(x, 8)) Then
- If ar(x, 8) = "达成" Then
- r = r + 1
- For l = 1 To UBound(ar, 2)
- br(r, l) = ar(x, l)
- Next
- End If
- End If
- Next
- Sheet2.Select: Rows("2:65500").Clear
- Range("a2").Resize(r, UBound(ar, 2)) = br
- MsgBox "汇总完毕"
- End Sub
复制代码 |
|