Macro find, replace a cell in that row

[it is I]

Hi all,

New here on the forum and new with macro so please be patient with me.

I'm trying to find a macro that would do the following:
1. Find a text in a range of cells in a different sheet (text that I search changes all the time, but the range is always the same)
2. when it finds the text, it should replace a cell in that row with a number from a specific cell

I was try to do it myself for 2 days now and no success. Does anyone have some macro that does this or a manual with useful commands (like find, replace, and so on..)

thx in advance.