|
楼主 |
发表于 2014-11-4 19:28
|
显示全部楼层
zjdh 发表于 2014-11-4 18:56
Sub TEST()
Set SH = Sheets("汇总")
SH.Rows("2:65536").ClearContents
For I = 1 To Sheets.Count
With Sheets(I)
If .Name <> "汇总" Then
For J = 1 To .Range("A1").End(2).Column
Set L = SH.Rows(1).Find(.Cells(1, J).Value)
If Not L Is Nothing Then
CL = L.Column
.Range(.Cells(2, J), .Cells(.Cells(65536, J).End(3).Row, J)).Copy SH.Cells(65536, CL).End(3)(2)
AAAA = .Range(.Cells(2, J), .Cells(.Cells(65536, J).End(3).Row, J))
End If
Next
|
|