VBA to update cell value based on another cell

[olympiac]

I need to update the values in column A based on the value in column B.
Here is the code:

If Range("A2").Value = "refrin" Then
Range("B2").Value = "RefrinDHP"

Else

End If
If Range("A3").Value = "refrin" Then
Range("B3").Value = "RefrinDHP"
etc......

I need to continue it until the end of the column.
Do I need to use a loop? Can you help please?

 

[pdenna1]

Now if I wanted it all to be the same, but instead of a formula, delete the row that matches Range("d" & i).Value = "Calendar"? Here's what i've tried before. Can I do multiple actions in an if statement?

If Range("d" & i) = "calendar" Then    
    Range(i).Select
    Selection.Delete Shift:=xlUp
    End If
    Next i

 

[Andrew Poulsom]

To delete rows you need to loop backwards:

For I = LastRow To 2 Step -1

 

[pdenna1]

What code do I need below along with For I = LastRow to 2 Step -1?

If Range("d" & i) = "calendar" Then        
Range(i).Select    
Selection.Delete Shift:=xlUp    
End If    
Next i

 

[pdenna1]

Never mind, I figured it out. Thanks for your help.

 

[propianoplayer]

I am using this macro on a spreadsheet with 30,000+ lines and it works but is very slow. Is there a way to speed it up?

 

[nicoenz]

it kinda solved my problem too!!!