- Option Explicit
- Sub t1()
- Dim ar, br, arow%, brow%, i%, j%, m%
- With Worksheets("T")
- arow = .Range("a65536").End(xlUp).Row
- End With
- With Worksheets("G")
- brow = .Range("a65536").End(xlUp).Row
- End With
- ReDim br(1 To arow + brow + m, 1 To 12)
- For i = 1 To Worksheets.Count - 1
- With Worksheets(i)
- ar = .Range("a3:i" & .Cells(Rows.Count, 1).End(xlUp).Row)
- End With
- For j = 1 To UBound(ar)
- m = m + 1
- br(m, 1) = m
- br(m, 4) = ar(j, 2)
- br(m, 5) = ar(j, 3)
- br(m, 6) = ar(j, 4)
- br(m, 7) = ar(j, 5)
- br(m, 10) = ar(j, 6)
- br(m, 11) = ar(j, 7)
- br(m, 12) = ar(j, 8)
- Next j
- Next i
- With Worksheets("TA")
- .Range("a3:l3") = Array("序号", "订单备注", "省份", "加盟店", "订单号.", "柜体材料", "門板材料", "门板材料", "", "客戶", "联系电话", "地址")
- .Range("a4").Resize(UBound(br, 1), UBound(br, 2)) = br
- End With
- End Sub
复制代码 |