The logic for this is confusing:-

compare C3 to columns D,F & H
if any values are the same as B3 replace them with the value in A3

C3 is therefore never actually used. Please clarify

Mike

"Finn" wrote:


Need some help to make a macro that check value in C3 against all values in
column D,F and H if any of the values are the same as in B3 it shall be
replaced withvalue in A3.

Then it shall go to C4 and do the same sheck With column D , F and H if
matching values too B4 replace them with value in A4 untill it reach the last
entry inn B column B


Finn