|
- Sub 提取()
- Dim xRng As Range
- arr = [a1].CurrentRegion
- ReDim brr(1 To 10000, 1 To 11)
- For i = 2 To UBound(arr)
- sfz = arr(i, 2) '身份证
- For Each sh In Worksheets
- Set xRng = sh.[g:g].Find(sfz)
- If Not xRng Is Nothing Then
- crr = sh.[a1].CurrentRegion
- hz = sh.Cells(xRng.Row, 1) '户主
- For k = 1 To UBound(crr)
- If crr(k, 1) = hz Then
- n = n + 1
- For j = 1 To 11
- brr(n, j) = crr(k, j)
- Next
- End If
- Next
- End If
- Next
- Next
- If n > 0 Then [e2].Resize(n, 11) = brr
- End Sub
复制代码 |
|