|
Sub test1()
Dim i, r
Sheets(1).Range("a4:c65536").ClearContents
For i = 3 To Sheets.Count
r = IIf(i = 3, 4, Cells(Rows.Count, 1).End(3).Row)
Sheets(i).Range("a4").CurrentRegion.Copy Sheets(1).Cells(r, 1)
Next i
End Sub
Sub test2()
Dim d, i, j, A
Set d = CreateObject("scripting.dictionary")
For i = 3 To Sheets.Count
A = Sheets(i).Range("a5").CurrentRegion
For j = 2 To UBound(A)
d(A(j, 1)) = d(A(j, 1)) + A(j, 3)
Next j
Next i
With Sheets(2)
.Range("a5:b65536").ClearContents
.Range("a5").Resize(d.Count) = Application.Transpose(d.keys)
.Range("b5").Resize(d.Count) = Application.Transpose(d.items)
End With
End Sub
2.rar
(11.71 KB, 下载次数: 7)
|
|