本帖最后由 scl5801 于 2016-2-13 22:14 编辑
Sub test()
Dim i&
With Sheets("表一")
For i = 6 To .[b65536].End(3).Row
.Cells(i, "j") = .Cells(i, "i") * .Cells(i, "f")
.Cells(i, "k") = .Cells(i, "h") - .Cells(i, "j")
Next
End With
With Sheets("表二")
For i = 6 To .[b65536].End(3).Row
.Cells(i, "i") = .Cells(i, "f") * 0.6
.Cells(i, "k") = .Cells(i, "j") * .Cells(i, "i")
.Cells(i, "l") = .Cells(i, "h") - .Cells(i, "k")
Next
End With
With Sheets("表三")
For i = 6 To .[b65536].End(3).Row
.Cells(i, "i") = .Cells(i, "f") * 0.6
.Cells(i, "k") = .Cells(i, "j") * .Cells(i, "i")
.Cells(i, "l") = .Cells(i, "h") - .Cells(i, "k")
Next
.Cells(7, "i") = .Cells(7, "f") * 0.1
.Cells(8, "i") = .Cells(7, "f") * 0.1
End With
End Sub