Hoping you all can give me a nudge in the right direction. I'm trying to do the below if/then with an AND and it's not working. I'm guessing I'm missing a reference for the bit after the AND, but not sure of the syntax.
Will add attachment, but essential this and code is below. Looking for a text to return in the Status Column.
Charter_Status Signature Status
Renewal Not Started No
Renewal Not Started No
On Hold No
In Progress Yes
On Hold No
In Progress No
Renewal Not Started No
Renewal Not Started No
In Progress Yes
On Hold No
Sub Macro2()
'
' Macro2 Macro
'
For Each Charter_Status In Range("A2:A11")
If Charter_Status = "Renewal Not Started" Then
Charter_Status.Offset(0, 2).Value = "Not Started"
ElseIf Charter_Status = "In Progress" And Signature = "Yes" Then
Charter_Status.Offset(0, 2).Value = "Waiting for FOR Signature"
ElseIf Charter_Status = "In Progress" And Waiting_FOR_Signature = "No" Then
Charter_Status.Offset(0, 2).Value = "In Progress"
ElseIf Charter_Status = "On Hold" Then
Charter_Status.Offset(0, 2).Value = "Hold"
End If
Next Charter_Status
'
End Sub
Bookmarks