|
发表于 2012-2-27 20:20
|
显示全部楼层
本楼为最佳答案
Sub 新增()
Dim Arr, Brr, Crr, iA, iB, iC, i, s
Application.ScreenUpdating = False
On Error Resume Next
Sheet11.Range("c2:dl30").ClearContents
Arr = Sheet5.Range("C2:DL30")
x = Sheet8.Range("iv30").End(xlToLeft).Column
Brr = Sheet8.Range(Sheet8.Cells(2, 3), Sheet8.Cells(30, Sheet8.Range("iv30").End(xlToLeft).Column))
ReDim Crr(1 To UBound(Brr, 1), 1 To UBound(Brr, 2))
For iB = 1 To UBound(Brr, 2) '期末列
For iA = 1 To UBound(Arr, 2) '期中列
If Brr(1, iB) = Arr(1, iA) Then '如果机构号相同
'判断期末机构号下是否都是0
s = 0
For i = 3 To 29
s = s + Brr(i, iB)
Next i
Crr(1, iB) = Brr(1, iB)
Crr(2, iB) = Brr(2, iB)
If s > 0 Then
For iC = 2 To UBound(Brr, 1)
x = Arr(iC, iA)
Crr(iC, iB) = Brr(iC, iB) - Arr(iC, iA)
Next iC
End If
End If
Next iA
Next iB
Sheet11.Activate
Range("a1") = Sheet2.Range("a5")
Cells(2, 3).Resize(UBound(Crr, 1), UBound(Crr, 2)) = Crr
Application.ScreenUpdating = True
End Sub
需求2.rar
(30.69 KB, 下载次数: 19)
|
|