|
发表于 2014-11-2 19:17
|
显示全部楼层
本楼为最佳答案
既然没有用SQL的话。- Sub 生成打印数据()
- Dim i%, j%, k%
- k = 4
- Dim sht As Worksheet
- Set sht = Worksheets("住院报销登记")
- With sht
- For i = 5 To .[A4].End(xlDown).Row
- If n = 35 Then n = 0: x = x + 1: k = 40 * x + 4
- If [H3] >= .Cells(i, 8) And .Cells(i, 8) >= [G3] Then
- If .Cells(i, 3) = [j3] Then
- If .Cells(i, 4) = [k3] Then
- If .Cells(i, 5) = [l3] Then
- n = n + 1: k = k + 1
- For j = 2 To 8
- Cells(k, j) = Worksheets("住院报销登记").Cells(i, j)
- Next
- End If
- End If
- End If
- End If
- Next
- End With
- End Sub
复制代码 |
评分
-
查看全部评分
|