|
Sub 汇总()
With Sheets("开票流水明细")
For i = 6 To 3000
For er = 6 To 3000
If Sheets("运费流水").Cells(i, 3) <> "" Then
For j = 9 To 3000
Cells(j, 6) = Sheets("运费流水").Cells(i, 3) '日期
Cells(j, 5) = Sheets("运费流水").Cells(i, 5) '车牌
Cells(j, 3) = Sheets("运费流水").Cells(i, 6) '姓名
Cells(j, 8) = Sheets("运费流水").Cells(i, 7) '车数
j = j + 1
ElseIf Sheets("运费流水").Cells(i, 9) <> "" Then
For k = j + 1 To 3000
Cells(k, 6) = Sheets("运费流水").Cells(er, 9) '日期
Cells(k, 5) = Sheets("运费流水").Cells(er, 11) '车牌
Cells(k, 3) = Sheets("运费流水").Cells(er, 12) '姓名
Cells(k, 8) = Sheets("运费流水").Cells(er, 13) '车数
k = k + 1
Else
MsgBox "汇总完成!", 64, "倒短工具"
End If
Next er
Next i
End With
End Sub
yunsin1015 发表于 2012-7-23 10:04
补充:我试着编了代码,可是运行时显示(else没有if)请高手检查下是什么地方错误? - Sub 汇总()
- With Sheets("开票流水明细")
- For i = 6 To 3000
- For er = 6 To 3000
- If Sheets("运费流水").Cells(i, 3) <> "" Then
- For j = 9 To 3000
- Cells(j, 6) = Sheets("运费流水").Cells(i, 3) '日期
- Cells(j, 5) = Sheets("运费流水").Cells(i, 5) '车牌
- Cells(j, 3) = Sheets("运费流水").Cells(i, 6) '姓名
- Cells(j, 8) = Sheets("运费流水").Cells(i, 7) '车数
- Next j
- ElseIf Sheets("运费流水").Cells(i, 9) <> "" Then
- For k = j + 1 To 3000
- Cells(k, 6) = Sheets("运费流水").Cells(er, 9) '日期
- Cells(k, 5) = Sheets("运费流水").Cells(er, 11) '车牌
- Cells(k, 3) = Sheets("运费流水").Cells(er, 12) '姓名
- Cells(k, 8) = Sheets("运费流水").Cells(er, 13) '车数
- Next k
- Else
- MsgBox "汇总完成!", 64, "倒短工具"
- End If
- Next er
- Next i
- End With
- End Sub
复制代码
|
|