|
发表于 2017-8-22 09:19
|
显示全部楼层
本楼为最佳答案
- Private Sub CommandButton3_Click()
- 'MsgBox "将(进货数据.销售数据)表中 与【A组数据】相匹配的内容 全替换为【B组数据】", 48
- Dim arr(1 To 5), brr(1 To 5), i, crr
- Dim str2$, Str$, n%, X%
- For i = 1 To 6
- If i <> 3 Then
- X = X + 1
- arr(X) = ListView2.SelectedItem.SubItems(i) 'B数据
- brr(X) = ListView1.SelectedItem.SubItems(i) 'A数据
- End If
- Next
- Str = Join(arr, "|")
- With Sheets("进货")
- crr = .Range("e8").CurrentRegion
- For i = 2 To UBound(crr) '开始于行8-->i+6
- If crr(i, 17) & "|" & crr(i, 21) & "|" & crr(i, 3) & "|" & crr(i, 4) & "|" & crr(i, 5) = Str Then
- n = n + 1
- .Cells(i + 6, "e") = brr(3)
- .Cells(i + 6, "F") = brr(4)
- .Cells(i + 6, "G") = brr(5)
- .Cells(i + 6, "W") = brr(2)
- .Cells(i + 6, "S") = brr(1)
- End If
- Next
- End With
- Erase crr
- With Sheets("销售")
- crr = .Range("e8").CurrentRegion
- For i = 2 To UBound(crr) '开始于行8-->i+6
- If crr(i, 17) & "|" & crr(i, 21) & "|" & crr(i, 3) & "|" & crr(i, 4) & "|" & crr(i, 5) = Str Then
- n = n + 1
- .Cells(i + 6, "e") = brr(3)
- .Cells(i + 6, "F") = brr(4)
- .Cells(i + 6, "G") = brr(5)
- .Cells(i + 6, "W") = brr(2)
- .Cells(i + 6, "S") = brr(1)
- End If
- Next
- End With
- Erase arr, brr, crr
- MsgBox n & "个已更改"
- End Sub
复制代码
改了,看下是否还有问题 |
|