The current macro only works on one column. I need it to work with two columns now. When columns O and Q both have a value of zero I want the the correspoding cells in column M to have the value of Canceled. Thanks for any help.
Sub Filling_In_Canceled()
Application.ScreenUpdating = False
For i = 1 To Cells(Rows.Count, "O").End(xlUp).Row
If Cells(i, "O") = "0" Then Cells(i, "M") = "Canceled"
Next i
End Sub
Sub Filling_In_Canceled()
Application.ScreenUpdating = False
For i = 1 To Cells(Rows.Count, "O").End(xlUp).Row
If Cells(i, "O") = "0" Then Cells(i, "M") = "Canceled"
Next i
End Sub