|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
- Sub 提取()
- t = Timer
- Dim i, x, y, rng As Range
- x = Sheets("户型").Range("b65536").End(xlUp).Row
- y = Sheets("方案").Range("A65536").End(xlUp).Row + 1
- arr = Sheets("户型").Range("a1:e" & x)
- brr = Sheets("方案").Range("a1:e" & y)
- For i = 3 To UBound(arr)
- For j = 3 To UBound(brr)
- With Sheets("方案")
- If arr(i, 1) <> "" And brr(j, 1) = arr(i, 1) Then
- arr(i, 3) = "=方案!" & Replace(.Cells(j, 1).Address, "A", "C")
- arr(i, 4) = "=方案!" & Replace(.Cells(j, 1).Address, "A", "D")
- arr(i, 5) = "=方案!" & Replace(.Cells(j, 1).Address, "A", "E")
- End If
- End With
- Next
- Next
- Sheets("户型").Range("a1").Resize(UBound(arr), UBound(arr, 2)) = arr
- MsgBox "提取完成!用时" & Timer - t & "秒!"
- End Sub
- 看看吧,有用请赏花,不知道我理解错没
复制代码 |
评分
-
1
查看全部评分
-
|