Livin404
Well-known Member
- Joined
- Jan 7, 2019
- Messages
- 743
- Office Version
- 365
- 2019
- Platform
- Windows
Greetings, I've tried using the macro below, but it is adding text to everything. Anytime "ACV" is NOT entered in Column G, I need to have "THRU-LOAD" placed in the corresponding row in Column M. Thank you,
VBA Code:
Sub THRU_LOAD()
Dim i As Long
For i = 1 To ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Row
Select Case Left(ActiveSheet.Cells(i, 3).Value, 3)
Case Is <> "ACV"
ActiveSheet.Range("N" & i) = "THRU-LOAD"
End Select
Next i
End Sub