Helloitsmemargaret
New Member
- Joined
- Jan 27, 2015
- Messages
- 4
Hi I am unable to get my macro to work to update one cell based off another cell. I need " Escalated to Issue" cells in Column N to transform "Risk" value cells in Column H to "Issue" value cells in Column H.
Can someone help![Smile :) :)](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
This is what I have
Sub Test()
Dim LastRow As Long
Dim i As Long
LastRow = Range("N" & Rows.Count).End(xlUp).Row
For i = 3 To LastRow
If Range("N" & i).Value = "Escalated to Issue" Then
Range("H" & i).Value = "Issue"
End If
Next cell
End Sub
Can someone help
This is what I have
Sub Test()
Dim LastRow As Long
Dim i As Long
LastRow = Range("N" & Rows.Count).End(xlUp).Row
For i = 3 To LastRow
If Range("N" & i).Value = "Escalated to Issue" Then
Range("H" & i).Value = "Issue"
End If
Next cell
End Sub