本帖最后由 爱疯 于 2017-2-8 17:30 编辑
Sub test()
Dim A, j
Application.ScreenUpdating = False
Call test2
A = Range("a1").CurrentRegion
For j = 5 To UBound(A, 2)
Sheets.Add(after:=Sheets(Sheets.Count)).Name = A(2, j)
Range("a1").Resize(UBound(A), 4) = A
Range("e1").Resize(UBound(A)) = Application.Index(A, 0, j)
Range("a:c").ColumnWidth = 30
Next j
Sheets(1).Select
End Sub
Sub test2()
Dim i
Application.DisplayAlerts = False
For i = 2 To Sheets.Count
Sheets(i).Delete
Next i
Sheets(1).Select
End Sub
商品调配表2.rar
(307.88 KB, 下载次数: 9)