Hi,
I have created a VBA with the condition whereby if the nos are greater than/equal than 31 and less than/equal to 46, the value will return 1 in column L.
But now, I want to add another condition whereby this will only be apply if column D is AA. Can anyone assist me on how to add that condition below?
Sub macros()
Dim lRow As Long
Sheets("COMVERSE").Select
lRow = Range("I" & Rows.Count).End(xlUp).Row
For i = 2 To lRow
If Cells(i, 9) >= 31 And Cells(i, 9) <= 46 Then
Cells(i, 12) = "1"
Else
Cells(i, 12) = "NO"
End If
Next i
End Sub
Bookmarks