Changing the values in a column
 

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?

--
Dirk

From what to what?

--
HTH

Bob Phillips

"Dirk_Bob" wrote in message
...
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?

--
Dirk

If the value in Cell 1 is "10" I want to change the value in Cell 2 to "Part"
--
Dirk


"Bob Phillips" wrote:

From what to what?

--
HTH

Bob Phillips

"Dirk_Bob" wrote in message
...
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?

--
Dirk

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

--
HTH

Bob Phillips

"Dirk_Bob" wrote in message
...
If the value in Cell 1 is "10" I want to change the value in Cell 2 to
"Part"
--
Dirk


"Bob Phillips" wrote:

From what to what?

--
HTH

Bob Phillips

"Dirk_Bob" wrote in message
...
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?

--
Dirk