Changing the values in a column

D

Dirk_Bob

I have several thousand rows in my spreadsheet.
My question is that I want to look at the value of one column and based on
its value, change the value of another column.

I would I do this?
 
B

Bob Phillips

For i = 1 To Cells(Rows.Count,"A").End(xlUp).Row
If Cells(i,"A").Value = "10" Then
Cells(i,"B").Value = "Part"
End If
Next i
 
Top