Hi Guys

I have a range lets say A1:A1000 with a product description in each cell. I need acode that will look through those cells and if any of them contain the word 'hello' then the word 'goodbye' would be put into the next cell.

For example if A1 had 'hello my name is simon' in it then after the code had run the word 'goodbye would appear in B1.

Any help would be much appreciated.