|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
查询的代码
- Option Base 1
- Sub chaxun()
- Dim arr, brr(20, 23)
- Dim sht As Worksheet
- ms = Sheet13.[d2].Value
- For Each sht In Worksheets
- If InStr(sht.Name, "月") Then
- arr = sht.Range("a4:y" & sht.Cells(sht.Rows.Count, 2).End(3).Row)
- For i = 1 To UBound(arr)
- If arr(i, 2) = ms Then
- X = X + 1
- brr(X, 1) = sht.Name
- For j = 4 To UBound(arr, 2)
- brr(X, j - 2) = arr(i, j)
- Next j
- Exit For
- End If
- Next i
- End If
- Next
- With Sheet13
- If X > 0 Then
- .UsedRange.Offset(4, 0).ClearContents
- .[a5].Resize(X, 23) = brr
- End If
- End With
- End Sub
复制代码
|
评分
-
3
查看全部评分
-
|