Sub myColumnCopy()
With Sheets(2)
.Columns(1).Copy Sheets(1).Range("A1")
.Columns(2).Copy Sheets(1).Range("B1")
.Columns(3).Copy Sheets(1).Range("C1")
.Columns(13).Copy Sheets(1).Range("J1")
.Columns(15).Copy Sheets(1).Range("K1")
.Columns(16).Copy Sheets(1).Range("L1")
End With
ThisWorkbook.SaveAs ThisWorkbook.Path & "\拼团申请-商品ID导入模板.xlsm"
End Sub
Sub myColumnCopy()
With Sheets(2)
.Columns(1).Copy Sheets(1).Range("A1")
.Columns(2).Copy Sheets(1).Range("B1")
.Columns(3).Copy Sheets(1).Range("C1")
.Columns(13).Copy Sheets(1).Range("J1")
.Columns(15).Copy Sheets(1).Range("K1")
.Columns(16).Copy Sheets(1).Range("L1")
End With
ThisWorkbook.SaveAs ThisWorkbook.Path & "\拼团申请-商品ID导入模板.xlsm"
End Sub