本帖最后由 Annalee9988 于 2021-3-20 10:42 编辑
Sub cdsr() Dim arr(1 To 10, 1 To 8), i&, k&, lastrow&, lastrow1& Dim ws As Worksheet Sheet3.Range("a2:h50000").ClearContents For Each ws In Worksheets If ws.Name <> "合并" Then With ws lastrow = .Cells(Rows.Count,6).End(xlUp).Row For i = 7 To lastrow k = k + 1 arr(k, 1) = .[b5] arr(k, 2) = .[k5] arr(k, 3) = .[k4] arr(k, 4) = .Cells(i, 2) arr(k, 5) = .Cells(i, 3) arr(k, 6) = .Cells(i, 4) arr(k, 7) = .Cells(i, 6) arr(k, 8) = .Cells(i, 7) Next End With lastrow1 = Sheet3.Cells(Rows.Count, 1).End(xlUp).Row + 1 Sheet3.Range("a" & lastrow1).Resize(k, 8) = arr Erase arr: k = 0 End If 我想将附档中每张表中的送货单,汇总到汇总表的明细表中,求大师指点,谢谢
两张分表的格式还是不一样的啊,一个有金额,一个没有金额。
|