请大神们帮我看下,怎么样简化代码,我只是想把多个表格中固定位置的数据汇总展示到一张表上。 Sub Data_() Dim i As Single For i = 1 To Worksheets.Count Cells(i + 1, 2) = Worksheets(i).Cells(4, 1) Next End Sub
Sub Data2_() Dim a As Single For a = 1 To Worksheets.Count Cells(a + 1, 3) = Worksheets(a).Cells(4, 2) Next End Sub
Sub Data3_() Dim b As Single For b = 1 To Worksheets.Count Cells(b + 1, 4) = Worksheets(b).Cells(4, 3) Next End Sub Sub Data4_() Dim c As Single For c = 1 To Worksheets.Count Cells(c + 1, 5) = Worksheets(c).Cells(5, 1) Next End Sub
Sub Data5_() Dim d As Single For d = 1 To Worksheets.Count Cells(d + 1, 6) = Worksheets(d).Cells(5, 2) Next End Sub
Sub Data6_() Dim e As Single For e = 1 To Worksheets.Count Cells(e + 1, 7) = Worksheets(e).Cells(5, 3) Next End Sub Sub Data7_() Dim f As Single For f = 1 To Worksheets.Count Cells(f + 1, 8) = Worksheets(f).Cells(6, 1) Next End Sub Sub Data8_() Dim j As Single For j = 1 To Worksheets.Count Cells(j + 1, 9) = Worksheets(j).Cells(6, 2) Next End Sub Sub Data9_() Dim h As Single For h = 1 To Worksheets.Count Cells(h + 1, 10) = Worksheets(h).Cells(6, 3) Next End Sub
|