Hi
I want to add the following conditions to the current macro. In the same format as shown in the VBA code.
All formaula to start at row 6
1. columns F+H+K = M
2. columns G+H+I = N
3. columns O = M - N
4. columns P = (N/M)-1
[VBA]
Sub Edit_Columns_2()
Application.ScreenUpdating = False
Dim lngLastRow As Long
lngLastRow = Cells(Rows.Count, "d").End(xlUp).Row
Range("k6:k" & lngLastRow).Value = Evaluate("=j6:j" & lngLastRow & "*c6:c" & lngLastRow)
Range("l6:l" & lngLastRow).Value = Range("d6:d" & lngLastRow).Value
Application.ScreenUpdating = True
End Sub
[/VBA]