|
更新一下。
- Sub 查询() '//2024.5.3
- With Sheets("单据明细")
- r = .Cells(Rows.Count, 4).End(3).Row
- arr = .[a1].Resize(r, 13)
- End With
- ReDim brr(1 To UBound(arr), 1 To UBound(arr, 2))
- With Sheets("送货单")
- dh = .[i4].Value
- .[a7:j16] = ""
- For i = 3 To UBound(arr)
- If arr(i, 4) = dh Then
- m = m + 1
- brr(m, 1) = m
- For j = 5 To UBound(arr, 2)
- brr(m, j - 3) = arr(i, j)
- Next
- End If
- Next
- .[a7].Resize(m, 10) = brr
- End With
- MsgBox "OK!"
- End Sub
- Sub 清空()
- With Sheets("送货单")
- .[i4:i5] = ""
- .[a7:j16] = ""
- End With
- End Sub
- Sub 保存() '//2024.5.3
- Set d = CreateObject("Scripting.Dictionary")
- With Sheets("单据明细")
- r = .Cells(Rows.Count, 4).End(3).Row
- arr = .[a1].Resize(r, 13)
- End With
- For i = 3 To UBound(arr)
- s = arr(i, 4)
- d(s) = ""
- Next
- ReDim brr(1 To UBound(arr), 1 To UBound(arr, 2))
- With Sheets("送货单")
- r = .Cells(Rows.Count, 1).End(3).Row
- arr = .[a1].Resize(r, 10)
- s = .[i4].Value
- If d.exists(s) Then
- MsgBox "单号明细表中已存在,现退出重来!"
- Exit Sub
- Else
- For i = 7 To UBound(arr)
- brr(m, 2) = .[i5].Value
- brr(m, 3) = .[b4].Value
- brr(m, 4) = s
- For j = 2 To UBound(arr, 2)
- brr(m, j + 3) = arr(i, j)
- Next
- Next
- End If
- End With
- With Sheets("单据明细")
- r = .Cells(Rows.Count, 4).End(3).Row
- .Cells(r + 1, 1).Resize(m, 13) = brr
- .Cells(r + 1, 1).Resize(m, 13).Borders.LineStyle = 1
- End With
- MsgBox "OK!"
- End Sub
复制代码
|
|