Sub xx()
Dim lastrow As Long
lastrow = Range("B65536").End(xlUp).Row()
Sheets("Sheet2").Select
For i = 2 To lastrow
For j = 2 To 8
Cells(j + 3, 3) = Sheet1.Cells(i, j)
next j
For j = 9 To 13
Cells(j - 4, 6) = Sheet1.Cells(i, j)
next j
Cells(14, 6) = Sheet1.Cells(i, 14)
Cells(13, 6) = Sheet1.Cells(i, 15)
ActiveWindow.SelectedSheets.PrintOut Copies:=1
next i
End Sub
尽可能详细些,谢谢
有QQ吗,兄弟,想请你帮我设计一个表格,谢谢