Extract certain data from file.

[satyen]

I am using VBA code to read formulas I have put in a Lookup table. It extracts information from a file and puts it into a Master file into the matching column. Looks at file column by column to extract data.

I need an excel formula or vba code to check whether one of the columns in a file contains the word "Happy" anywhere in the string. If it does exit loop, otherwise copy the data accross to the Master sheet. I'm not sure the best way to tackle this.

[Bob Phillips]

Something like

[vba]

If Application.CountIf(Columns("C:C"),"*Happy*") > 0 Then

'etc.
[/vba]