|
大家好!
有个问题想要大家帮助, 附件中想要用VBA查询某一时间段的牛号,牛号对应的有多个配种记录。
谢谢!
- Sub Macro1()
- Dim arr, brr, crr, d, i&
- Set d = CreateObject("scripting.dictionary")
- arr = Sheet1.Range("a1").CurrentRegion
- Sheet2.Activate
- brr = Range("b8:b" & Range("b65536").End(xlUp).Row)
- ReDim crr(1 To UBound(brr), 1 To 1)
- d1 = [c5]: d2 = [c6]
- For i = 3 To UBound(arr)
- If arr(i, 2) >= d1 And arr(i, 2) <= d2 Then d(arr(i, 1)) = ""
- Next
- For i = 1 To UBound(brr)
- If d.exists(brr(i, 1)) Then crr(i, 1) = brr(i, 1)
- Next
- Range("c8").Resize(UBound(crr)) = crr
- End Sub
复制代码
|
|