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

日期:2014-03-26 16:04:20 人气:1

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

在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
    A+
热门评论