Option Explicit
Sub TEST1()
Dim arr, i As Integer
With Sheets("訂購單")
For i = 10 To Application.CountA(.[A10:A16]) + 9
arr = Array(.[L4], .[N4], .[L7].Text, .Cells(i, "A"), .Cells(i, "C"), .Cells(i, "E"), .Cells(i, "H"), .Cells(i, "I"), .Cells(i, "J"), .Cells(i, "L"))
Sheets("訂購記錄").Cells([A65536].End(3).Row + 1, 1).Resize(1, UBound(arr)) = arr
Next
End With
End Sub