|
之后改红色的地方就可以了
Sub demo()
Header = 7
a = Sheets(1).UsedRange
r = 1
With Sheets(2)
.UsedRange.Offset(1, 0).ClearContents
.Range(Cells(1, Header + 4), Cells(1, "xfd")).Clear
For i = 2 To UBound(a)
If a(i, 1) <> p Then
r = r + 1: c = Header - 2
.Cells(r, 1).Resize(1, Header) = Array(a(i, 1), a(i, 2), a(i, 3), 4, 5, 6, 7)
p = a(i, 1)
End If
c = c + 3: If c > maxc Then maxc = c
.Cells(r, c).Resize(1, 3) = Array(a(i, 12), a(i, 14), a(i, 15))
Next
.Cells(1, Header + 1).Resize(1, 3).Copy .Cells(1, Header + 1).Resize(, maxc + 2 - Header)
.Columns(1).Resize(, maxc + 2).AutoFit
End With
End Sub
祝順心,南無阿彌陀佛!
|
|