|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
Sub 按钮393_Click()
Dim arr(1 To 9999, 4 To 16)
Set d = CreateObject("scripting.dictionary")
Application.ScreenUpdating = False
Application.Calculation = xlAutomatic
Sheets("汇总").Select
r = Cells(Rows.Count, 4).End(3).Row
Range("d7:p" & r).ClearContents
r = 0
For Each sh In Sheets
If InStr(sh.Name, "工资") > 0 Then
brr = sh.UsedRange
For j = 5 To UBound(brr)
If Len(brr(j, 2)) <> 0 Then
If Not d.exists(brr(j, 2) & "") Then
r = r + 1
arr(r, 4) = brr(j, 2)
arr(r, 5) = brr(j, 3)
arr(r, 6) = brr(j, 6)
d(brr(j, 2) & "") = r
End If
End If
Next j
End If
Next sh
For Each sh In Sheets
If InStr(sh.Name, "其他收入") > 0 Then
brr = sh.UsedRange
For j = 9 To UBound(brr)
If Len(brr(j, 5)) <> 0 Then
If Not d.exists(brr(j, 5) & "") Then
r = r + 1
arr(r, 4) = brr(j, 5)
arr(r, 5) = brr(j, 4)
For i = 1 To 10
arr(r, i + 6) = Val(brr(j, i + 8))
Next i
Else
x = d(brr(j, 5) & "")
For i = 1 To 10
arr(x, i + 6) = Val(arr(x, i + 6)) + Val(brr(j, i + 8))
Next i
End If
End If
Next j
End If
Next sh
[d7].Resize(r, 13) = arr
Application.Calculation = xlManual
Application.ScreenUpdating = True
End Sub
|
|