Please help. I have an excel file, I wanted it to search for a word let's say "marketing" from column A5:CH5(or maybe more) and wanted it to copy the entire columns that contains the word marketing next to the original columns. There will be more than 1 column that contains the word marketing and the contents may differ for differnt column.

ps:marketing maybe just part of the whole sentence in the columns

Your help is much appreciated... Thank you

How does you application work, with excel?
please show some code