Question

excel根据sheet1的A1,A2,A3的数值,比如是3,4,5,在sheet2的A1,A2,A3往右填充相应的内容

Answer 1

在Sheet2输入并执行如下VBA程序：

Sub try()

Dim i As Integer, j As Integer

For i = 1 To 3

For j = 1 To Sheet1.Range("A" & i).Value

Cells(i, j) = Sheet1.Range("A" & i).Value

Next j

Next i

End Su