Sub 工资表格式() krow = Sheet1.Range("a65536").End(xlUp).Row
Y = 2 For X = 1 To krow * 2 - 2 Step 2 Sheet2.Range(Cells(X, "A"), Cells(X, "E")) = Sheet1.Range("a1:e1").Value Sheet2.Range(Cells(X + 1, "A"), Cells(X + 1, "E")) = Sheet1.Range("A" & Y & ":E" & Y).Value 'Cells(Y, "A"), Cells(Y, "E")).Value Y = Y + 1 Next X End Sub
Sub 工资表格式() krow = Sheet1.Range("a65536").End(xlUp).Row
Y = 2 For X = 1 To krow * 2 - 2 Step 2 Sheet2.Range(Cells(X, "A"), Cells(X, "E")) = Sheet1.Range("a1:e1").Value Sheet2.Range(Cells(X + 1, "A"), Cells(X + 1, "E")) = Sheet1.Range("A" & Y & ":E" & Y).Value 'Cells(Y, "A"), Cells(Y, "E")).Value Y = Y + 1 Next X End Sub