Need a code: if the line on collum on left is filled with some value, this collumn

[coringa]

HI friends. I need a code. I have the column A

I need a code that if this line on collumn A is filled with some value<0, and it will be applied to all collumn A, it will imediatelly store (dont simply copy because these other cell changes

its values too) on collumn B on the same line that collumn A new number, the value of lets say H5 cell(third cell).

[coringa]

Thanks everybody for not helping

[Alf]

You are welcome.

But most of the time people don't get an answer because forum member don't understand the problem. This is one reason why uploading a file showing "before" and "after" is a much better way to get help.

Finally, the members who spend time and effort to help others are not paid to do so adding a bit of sarcasm as a posting after a day will most likely only ensure that nobody will take any notice of your thread.

Alf