Option Explicit
'创建方式2: 用数据透视表向导来创建
Sub test3()
Dim i&
Dim A
On Error Resume Next
For i = 12 To 1000 '定义足够大了。EXCEL 内置最小是从12开始,本身有11个。
Application.DeleteCustomList ListNum:=i
Next i
Application.AddCustomList [e19:e24]
On Error GoTo 0
Sheets.Add after:=Sheets(Sheets.Count)
With ActiveSheet.PivotTableWizard(xlDatabase, Sheets(1).[a1].CurrentRegion)
.PivotFields("货号").Orientation = xlRowField
.PivotFields("尺寸").Orientation = xlColumnField
.PivotFields("数量").Orientation = xlDataField
End With
A = Range("a1").CurrentRegion.Offset(1, 0)
Cells.Clear
Range("a1").Resize(UBound(A), UBound(A, 2)).Value = A
Range("a1").CurrentRegion.Borders.LineStyle = 1
End Sub