|
本帖最后由 Excel学徒123 于 2014-12-8 17:07 编辑
- Sub 提取内容()
- Dim arr, arr1(1 To 10000, 1 To 48)
- Dim i, j, Intarr, Tx, Ends
- Ends = Sheets("数据库").Cells(Rows.Count, 1).End(3).Row
- arr = Sheets("数据库").Range("A7:AV" & Ends)
- For i = 1 To UBound(arr)
- For Tx = 7 To Sheets("明细表").Cells(Rows.Count, 2).End(3).Row
- If arr(i, 2) = Sheets("明细表").Range("B" & Tx) And arr(i, 3) = Sheets("明细表").Range("c" & Tx) Then
- j = j + 1
- For Intarr = 1 To 48
- arr1(j, Intarr) = arr(i, Intarr)
- Next
- Sheets("明细表").Range("A" & Tx).Resize(j, 48) = arr1
- End If
- j = 0
- Next Tx
- Next i
-
- End Sub
复制代码 按照你的表做出来了,把代码Copy带模块里运行吧,看是否达到你的要求 |
|