Need Macro that returns a "true" value in a new column for each row that contains a search term

[DLR1981]

Hi Everyone,

I have a spreadsheet that contains 6 columns. One of the columns contains system descriptions, which may run a paragraph or two in length. I would like to create a Macro that searches the system description column for a key word and returns "true" in a new column.

For example, if I search for "content management," I would like a macro that returns in a new column on the same spreadsheet a value of "true" in the row(s) that contains the term "content management" in the system description column (column H). Ideally, I'd like to be able to search for multiple terms on the same spreadsheet, such that if I search for "content management," all "true" values in return in column I, and if I search for "case management" all true values are returned in column J, and so on...

Does anyone know how to do this?

 

[DLR1981]

Hi Rick,

I am getting the following error on this line: "If InStr(1, Data(R, C), Phrase, vbTextCompare) Then"

 

[Rick Rothstein]

Hi Rick,

I am getting the following error on this line: "If InStr(1, Data(R, C), Phrase, vbTextCompare) Then"

And the error (number and description) that you are getting on that line is....?

 

[DLR1981]

Sorry about that... Error 2042

 

[DLR1981]

Rats. It looks like I have N/A in some of my cells...

 

[DLR1981]

Rick,

It works!!! I had to replace the N/As. Now it works beautifully!! Thank you!!!

 

[Rick Rothstein]

Rick,

It works!!! I had to replace the N/As. Now it works beautifully!! Thank you!!!

Great... glad to hear it. And, of course, you are quite welcome.