Copy values across columns

[tarki]

I am having a hard time with a copying values, it is best if I make an example.
The idea is: if A1 is "Toyota" and there is some other text also in B1, B2 and B3 then A1,A2 and A3 are "Toyota"

Book1.xls

[perimidt]

Hi

Is a macro ok? I think this does what you want:

Please Login or Register  to view this content.

Copy values across columns.xls

[tarki]

Hi Per Erik!

This is almost the thing, but the thing is that the data in column A and B are different sometimes. Sometimes there is "Toyota" in B1:B3, But A1 already has a value (lets say "HONDA"), but does not have A2 nor A3 with the same value. And there always has to be the same amount of entries in column A as there are in Column B

[perimidt]

But this macro would put "HONDA" in A2 and A3 if that was the case, is that not what you want it to?

[tarki]

Oh my! My stupid mistake!

Thank you Per Erik! You saved my little brain