|
发表于 2012-1-13 10:21
|
显示全部楼层
本楼为最佳答案
本帖最后由 sunjing-zxl 于 2012-1-13 10:22 编辑
- Sub aa()
- Dim arr1, arr2, arr3
- Dim i As Long, j As Long, n As Long
- Dim bm As String
- arr1 = Range("A4:F" & [A65536].End(xlUp).Row)
- n = Month(Cells(1, 2))
- For i = 1 To UBound(arr1)
- If arr1(i, 3) = "" Then
- Exit For
- Else
- bm = arr1(i, 3)
- With Sheets(bm)
- arr2 = .Range(.Cells(3, 1), .Cells(.[A65536].End(xlUp).Row, 14))
- arr3 = .Range(.Cells(3, 15), .Cells(.[A65536].End(xlUp).Row, 26))
- End With
- End If
- For j = 1 To UBound(arr2)
- If arr1(i, 1) = arr2(j, 1) Then
- If arr2(j, n + 2) + arr1(i, 6) > arr3(j, n) Then
- MsgBox arr1(i, 3) & arr1(i, 1) & "费用超预算并不更新数据"
- Else
- Sheets(bm).Cells(j + 2, n + 2) = arr2(j, n + 2) + arr1(i, 6)
- MsgBox arr1(i, 3) & arr1(i, 1) & "费用更新至" & arr2(j, n + 2) + arr1(i, 6)
- End If
- Exit For
- End If
- Next j
- Next i
- MsgBox "数据更新完成"
- End Sub
-
复制代码 附件:
样表-sunjing.rar
(13.64 KB, 下载次数: 22)
|
|