2,463
社区成员
发帖
与我相关
我的任务
分享
Sub 生成表格()
Dim i As Integer
i = 1
Do While Cells("5i-4", "A").Value <> ""
Cells(i, "E").Value = Cells("5i-4", "A").Value
Cells(i, "F").Value = Cells("5i-4", "C").Value
Cells(i, "G").Value = Cells("5i-3", "C").Value
Cells(i, "H").Value = Cells("5i-2", "C").Value
Cells(i, "I").Value = Cells("5i-1", "C").Value
Cells(i, "J").Value = Cells("5i", "C").Value
i = i + 1
Loop
End Sub
Cells("5i-4", "A").Value
改成Cells(5*i-4, "A").Value