Find in column B, copy/paste from column C

[jbentley73]

This seems like it should be simple, but I haven't found a solution yet.

I am trying to go through a list of television shows where there is a column with the network (Col A), a column with a program name (Col B), and a column with an episode or movie title (Col C).

Where a movie has aired, the program name will usually be something that says "movie" in it (e.g. BET Movie of the Week, FX Morning Movie).

When "movie" appears in a cell of column B, I want to copy/paste the movie title from column C left into Col B.

I would show some code, but so far nothing has really come close to working.

[NBVC]

You could use a helper column formula like in D5:

=IF(ISNUMBER(SEARCH("movie",B5)),C5,B5)

copied down.

Then you can copy the column D range and paste special, selecting Values over column B. Then delete column D.

[snb]

or using VBA:

Please Login or Register  to view this content.

[jbentley73]

The VBA code worked almost perfectly--only problem is that I wanted to replace the program name (Col B), not just insert the movie title (Col C).

[NBVC]

Using the formula method is just as quick and works as you requested.

[jbentley73]

The helper column formula worked!

Thanks so very much!

[snb]

The amended VBA method:

Please Login or Register  to view this content.