|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
查询的代码写完了,建议你在新的sheet里查询打印- Sub 查询()
- arr = Sheet4.UsedRange
- For m = 3 To UBound(arr)
- If [b6] = arr(m, 2) Then
- [e5] = arr(m, 3): [e6] = arr(m, 4): [h8] = arr(m, 5)
- [f9] = arr(m, 6): [h9] = arr(m, 7): [j9] = arr(m, 8)
- [h10] = arr(m, 9): [f11] = arr(m, 10): [h11] = arr(m, 11)
- [j11] = arr(m, 12): [h12] = arr(m, 13): [f13] = arr(m, 14)
- [h13] = arr(m, 15): [j13] = arr(m, 16): [f14] = arr(m, 17)
- [h14] = arr(m, 18): [j14] = arr(m, 19): [h15] = arr(m, 20)
- [f16] = arr(m, 21): [h16] = arr(m, 22): [j16] = arr(m, 23)
- [f17] = arr(m, 24): [h17] = arr(m, 25): [j17] = arr(m, 26)
- [e18] = arr(m, 27): [e21] = arr(m, 28): [e24] = arr(m, 29)
- [e25] = arr(m, 30): [e26] = arr(m, 31): [e27] = arr(m, 32)
- End If
- Next
- End Sub
复制代码 |
评分
-
1
查看全部评分
-
|