|
提取多个工作表固定行之后的所有数据汇总到一张表中 关键是如何显示原表名称 谢谢
- Sub demo()
- Dim ar, br(1 To 60000, 1 To 9), n, x, i, j
- For x = 2 To Sheets.Count
- ar = Sheets(x).Range("a7:h" & Sheets(x).Cells(Rows.Count, 1).End(3).Row)
- For i = 1 To UBound(ar)
- n = n + 1
- br(n, 1) = Sheets(x).Name
- For j = 1 To UBound(ar, 2)
- br(n, j + 1) = ar(i, j)
- Next
- Next
- Next
- Sheet1.Range("a2").Resize(n, 9) = br
- End Sub
复制代码
|
|