Macro to duplicate cells with a certain string across columns

[tisahardknocklife]

Hi Everyone!

I'm looking for a pretty simple macro that will help me accomplish this task:

Suppose I have cells that read as follows:

A1: 345
A2: 123
A3: 345
A4: 456

I'd like macro that would paste cells containing the string "34" to columns B, C, and D

So after it is run,

the file would be as follows:

A1: 345 B1: 345 C1: 345 D1: 345
A2: 123
A3: 345 B1: 345 C1: 345 D1: 345
A4: 456

Thanks!

[YasserKhalil]

Hello try this code

Please Login or Register  to view this content.

[alansidman]

Please Login or Register  to view this content.

[mehmetcik]

Please Login or Register  to view this content.

[JLGWhiz]

You can take your choice. If 34 is anywhere in the string then

Please Login or Register  to view this content.

If 34 is the first two characters of the string then:

Please Login or Register  to view this content.

[tisahardknocklife]

Thanks everyone!

Got exactly what I needed!