Hey All,

I was able to find a query I could throw in each cell of a worksheet that looked at the cell in first column of the same row for keywords and displayed them in the new cell if there was a hit (each column had a different keyword). But, because I'm working with 10's of thousands of rows, the xls document is really slow to open and respond. Is there a way to take the following code and turn it into a module that only runs when I activate it?:

=If(sumproduct(--(isnumber(search({"xxx","xxx"},A2))))>0,A2,"")

Example of how it works...

Column A, Column B "Dog", Column C "Cat"
Fish, ,
Horse, ,
Dog, Dog,
Cat, , Cat