|
- Sub tj()
- Set d = CreateObject("scripting.dictionary")
- [c5:L14].ClearContents
- arr = Range("a5:l14")
- For i = 1 To UBound(arr)
- d(arr(i, 2)) = i
- Next
-
- Application.ScreenUpdating = False
- Dim Filename, wb As Workbook, Sht As Worksheet
- Filename = Dir(ThisWorkbook.Path & "\*.xls")
- Do While Filename <> ""
- If Filename <> ThisWorkbook.Name Then
- fn = ThisWorkbook.Path & "" & Filename
- Set wb = Workbooks.Open(fn)
- brr = wb.Worksheets(1).[a1].CurrentRegion
- For k = 5 To UBound(brr)
- i = d(brr(k, 3))
- If i > 0 Then
- For j = 1 To 5
- arr(i, j + 2) = arr(i, j + 2) + brr(k, j + 6)
- Next
- arr(i, 8) = arr(i, 7)
- For j = 1 To 4
- arr(i, j + 8) = arr(i, j + 8) + brr(k, j + 13)
- Next
- End If
- Next
- wb.Close False
- End If
- Filename = Dir
- Loop
- Range("a5:l14") = arr
- Application.ScreenUpdating = True
- End Sub
复制代码 |
评分
-
查看全部评分
|