Hi Experts

I am new to Excel Macro. I am looking for the Macro which finds for the Specific Word in the Entire Column if found it should update a new column with specific word.

For Eg.

I have Column which contains list of Application. in that list of Application Macro with search for Keyword "Update,KB" if found it should write in new colum corresponds to Found Row with Key word "Update".

Need Help.