|
发表于 2017-6-28 13:53
|
显示全部楼层
本楼为最佳答案
本帖最后由 chart888 于 2017-6-28 13:54 编辑
- Private Sub CommandButton1_Click()
- Dim Arr, Brr
- Dim i, j
- Application.ScreenUpdating = False
- Set d = CreateObject("scripting.dictionary")
- Arr = Worksheets("总表").[A1].CurrentRegion
- For i = 2 To UBound(Arr)
- d(Arr(i, 1)) = Arr(i, 2)
- Next
- With Worksheets("明细表")
- r = .Cells(Rows.Count, 1).End(3).Row
- Brr = Worksheets("明细表").Range("A2:B" & r)
- For j = 1 To UBound(Brr)
- If d.exists(Brr(j, 1)) Then
- Brr(j, 2) = d(Brr(j, 1))
- End If
- Next
- .Range("A2:B" & r).ClearContents
- .Range("A2:B" & r) = Brr
- End With
- Application.ScreenUpdating = True
- End Sub
复制代码
|
|