|
- Sub t()
- Dim arr, arr1, arr2
- arr = Sheet1.Range("B3:C" & Sheet1.Range("B65536").End(xlUp).Row)
- arr1 = Sheet2.Range("B3:B" & Sheet2.Range("B65536").End(xlUp).Row)
- ReDim arr2(1 To UBound(arr1, 1), 1 To 1)
- For i = 1 To UBound(arr1, 1)
- For j = 1 To UBound(arr, 1)
- If arr(j, 1) = arr1(i, 1) Then
- arr2(i, 1) = arr(j, 2)
- i = i + 1
- Else
- arr2(i, 1) = arr1(i, 1)
- End If
- Next
- Next
- Sheet2.Cells(3, 3).Resize(UBound(arr1, 1), 1).ClearContents
- Sheet2.Cells(3, 3).Resize(UBound(arr1, 1), 1) = arr2
- End Sub
复制代码 |
|