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