|
发表于 2014-3-24 21:40
|
显示全部楼层
本楼为最佳答案
- Sub Macro1()
- On Error Resume Next
- Dim arr, i&, j%, x&, y&
- arr = Sheets("编号").Range("a1").CurrentRegion
- For j = 5 To Sheets.Count
- Sheets(j).UsedRange.Clear
- Next
- For i = 2 To UBound(arr)
- zf = "" & arr(i, 2)
- For j = 2 To 4
- With Sheets(j)
- x = Sheets(zf).UsedRange.Find(arr(i, 2), SearchDirection:=xlPrevious).Row
- y = IIf(j = 2, 1, x + 2)
- .Range("I1").AutoFilter Field:=9, Criteria1:=arr(i, 2)
- .UsedRange.SpecialCells(xlCellTypeVisible).Copy Sheets(zf).Cells(y, 1)
- .ShowAllData
- End With
- Next
- x = Sheets(zf).UsedRange.Find(arr(i, 2), SearchDirection:=xlPrevious).Row
- Union(Sheets(zf).Range(x + 1 & ":" & 20000), Sheets(zf).[i:i]).Clear
- Sheets(zf).[i1] = Application.Sum(Sheets(zf).Range("g2:g" & x))
- Next
- End Sub
复制代码 I1有金额总合计
|
|