Move cells containing specific content into a specific column

Hi folks,

I need a macro that will look for all cells that contain a certain word and move it over to a specific column (but not change rows).

Basically I'm trying to organize data that looks like this:

title X | chap. 2 | sec. 6 | subchap. 17 |
chap. 1| subchap. 2 |
title XX | chap. 3 | subchap. 4 |
title II | chap. 4 | sec. 7 | subchap. 9 |

And, for example, I'd like to take all instances of the word "title" and move it over to column L but stay in the same row. Thanks in advance!

Originally Posted by patel45

attach a sample file for testing

Sure!
sampleuscode.xls