excel根据sheet1的A1,A2,A3的数值,比如是3,4,5,在sheet2的A1,A2,A3往右填充相应的内容
excel根据sheet1的A1,A2,A3的数值,比如是3,4,5,在sheet2的A1,A2,A3往右填充相应的内容
日期:2014-03-26 16:04:20 人气: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 Sub