Each week i receive a spread sheet with many rows and columns of data.

Im only interested in about 10 rows scattered throughout the sheet.

In column "W" I scan and look for the rows I require. Im looking for words like MNBS and MNBC... Each row has a Key work that pertains to me.

It there a script that I can make that will search the column "W" each week for words I look for, then just show me these rows.

IE.. ( i don't know code so gone laugh) Get Row W MNBS,MNBC...

Thank you

Todd