|
发表于 2013-7-8 21:36
|
显示全部楼层
本楼为最佳答案
附件请测试- Private Sub CommandButton1_Click()
- Dim arr, i&, j&
- arr = UsedRange
- ReDim Preserve arr(1 To UBound(arr), 1 To UBound(arr, 2) + 1)
- For j = 1 To UBound(arr)
- K = 0
- For i = 1 To UBound(arr)
- If arr(j, 5) = arr(i, 1) Then
- If arr(i, 2) = "" Then
- arr(i, 2) = arr(j, 6)
- Else
- arr(i, 3) = arr(j, 6)
- End If
- K = K + 1
- End If
- Next i
- If K = 0 Then arr(j, 7) = "X"
- Next j
- [A1].Resize(UBound(arr), UBound(arr, 2)) = arr
- End Sub
复制代码 |
|