Update Excel spreadsheet

[bayman]

Is it possible to:

Search a spreadsheet for a particular key value and, if found, update another cell in the spreadsheet row? If so, how?

Thanks in advance.

 

[doulostheou]

Yes. I would use a for statement. The following example will search the first 500 cells in column 1 for "Test" and if found place the word "Test" in column 3 of the same row:

For r = 1 to 500
If cells(r, 1) = "Test" Then
cells(r,3) = cells(r,1)
End If
Next