|
过程都在附件中写了,这里也不知道怎么描述,麻烦有时间的大神,帮忙看看.成分感谢.
- Private Sub CommandButton1_Click()
- Dim r, Arr, i, j
- Application.ScreenUpdating = False
- Set d = CreateObject("Scripting.Dictionary")
- With Worksheets("Sheet3")
- Arr = Worksheets("表格1").[A1].CurrentRegion
- For j = 2 To UBound(Arr)
- d(Arr(j, 4)) = j
- Next
- r = .Range("A65536").End(xlUp).Row
- For i = 2 To r
- .Cells(i, 8) = .Cells(i, 1) & "-" & .Cells(i, 3)
- If d.exists(.Cells(i, 8).Value) Then
- j = d(.Cells(i, 8).Value)
- .Cells(i, 10) = Arr(j, 6)
- .Cells(i, 11) = Arr(j, 9)
- End If
- .Cells(i, 9) = .Cells(i, 10) & "," & .Cells(i, 2)
- Next
- End With
- Application.ScreenUpdating = True
- End Sub
复制代码
|
|