|
发表于 2012-1-8 22:46
|
显示全部楼层
本楼为最佳答案
本帖最后由 sunjing-zxl 于 2012-1-8 22:47 编辑
- Sub czsj()
- Dim arr1, arr2, arr3, arr4
- Dim i As Long, j As Long, n As Long, k As Long
- Range("C2:G5").ClearContents
- With Sheets("表1")
- arr1 = .Range("A2:F" & .[a65536].End(xlUp).Row)
- arr2 = .Range("G2:K" & .[g65536].End(xlUp).Row)
- End With
- n = Cells(1, 1)
- ReDim arr3(1 To 4, 1 To 5)
- arr4 = Range("B2:B5")
- For i = 1 To UBound(arr1)
- If VBA.Day(arr1(i, 1)) = n Then
- For j = 1 To 4
- If arr1(i, 2) = arr4(j, 1) Then
- For k = 1 To 4
- arr3(j, k) = arr1(i, 2 + k)
- Next k
- arr3(j, 5) = arr2(n, j + 1)
- End If
- Next j
- End If
- Next i
- Range("C2").Resize(4, 5) = arr3
- End Sub
复制代码 附件:
查找数据-sunjing.rar
(13.13 KB, 下载次数: 17)
|
|