加一句清除数据的代码,以便更新:- Sub lsc()
- Sheets("装配生产主计划").UsedRange.Offset(5, 1).ClearContents
- Sheets("仪器生产主计划").UsedRange.Offset(5, 1).ClearContents
- arr = Sheets("销售订单明细").UsedRange
- ReDim brr(1 To UBound(arr), 1 To 5)
- ReDim crr(1 To UBound(arr), 1 To 5)
- For i = 2 To UBound(arr)
- If arr(i, 3) Like "*装配*" Then
- m = m + 1
- brr(m, 1) = arr(i, 4): brr(m, 2) = arr(i, 1): brr(m, 3) = arr(i, 5): brr(m, 4) = arr(i, 9): brr(m, 5) = arr(i, 7)
- End If
- If arr(i, 3) Like "*仪器*" Then
- n = n + 1
- crr(n, 1) = arr(i, 4): crr(n, 2) = arr(i, 1): crr(n, 3) = arr(i, 5): crr(n, 4) = arr(i, 9): crr(n, 5) = arr(i, 7)
- End If
- Next
- Sheets("装配生产主计划").[b5].Resize(m, 5) = brr
- Sheets("仪器生产主计划").[b5].Resize(n, 5) = crr
- End Sub
复制代码 |