|
发表于 2011-11-14 13:41
|
显示全部楼层
本楼为最佳答案
本帖最后由 wayy 于 2011-11-14 13:42 编辑
- Private Sub CommandButton1_Click()
- Dim i As Long
- Dim h As Long
- Dim xm As String
- xm = [b2].Value
- Dim arr1, arr2
- With Sheet5
- arr1 = .Range("C2", .[N65536].End(xlUp))
- End With
- ReDim arr2(1 To UBound(arr1), 1 To 11)
- For i = 1 To UBound(arr1)
- If arr1(i, 5) = xm And arr1(i, 2) <> "A" And arr1(i, 2) <> "B" Then
- h = h + 1
- arr2(h, 1) = arr1(i, 1)
- arr2(h, 2) = arr1(i, 2)
- arr2(h, 3) = arr1(i, 3)
- arr2(h, 4) = arr1(i, 4)
- arr2(h, 5) = arr1(i, 6)
- arr2(h, 6) = arr1(i, 8)
- arr2(h, 7) = arr1(i, 9)
- arr2(h, 8) = arr1(i, 10)
- arr2(h, 9) = arr1(i, 11)
- arr2(h, 10) = arr1(i, 12)
- If h = 1 Then
- arr2(h, 11) = arr1(i, 8) * 1 - arr1(i, 12) * 1
- Else
- arr2(h, 11) = arr1(i, 8) - arr1(i, 12) + arr2(h - 1, 11)
- End If
- End If
- Next
- Sheet6.Select
- Range("A4:K65536").ClearContents
- Range("A4").Resize(h, 11) = arr2
- MsgBox "数据提取完毕!!", , "wayy提示您"
- End Sub
复制代码
这个完全可以自己加下,不要把全部的要求都让别人给完成,自己却不会,以后改还是需要自己去学着改的。
PS:授人以渔比授人以鱼更重要。 |
|