|
- Sub test()
- arr = Sheets("def").UsedRange
- brr = Sheets("abc").Cells(4, 3).CurrentRegion.Resize(, 2)
- For i = 1 To UBound(brr)
- For j = 1 To UBound(arr)
- If arr(j, 1) = brr(i, 1) Then brr(i, 2) = arr(j, 2)
- Next
- Next
- Sheets("abc").Cells(4, 3).Resize(UBound(brr), 2) = brr
- End Sub
复制代码 供参考 |
|