|
发表于 2014-11-2 09:12
|
显示全部楼层
本楼为最佳答案
本帖最后由 qh8600 于 2014-11-2 09:14 编辑
- Sub xx()
- Dim i%, j%, k%
- k = 4
- For i = 5 To Worksheets("住院报销登记").[a4].End(xlDown).Row
- If n = 35 Then n = 0: x = x + 1: k = 40 * x + 4
- If [g3] >= Worksheets("住院报销登记").Cells(i, 7) And Worksheets("住院报销登记").Cells(i, 7) >= [f3] Then
- n = n + 1: k = k + 1
- For j = 2 To 7
- Cells(k, j) = Worksheets("住院报销登记").Cells(i, j)
- Next
- End If
- Next
- End Sub
复制代码 楼主试试
|
评分
-
查看全部评分
|