Excel gurus, I need your help

[Homerboy]

I have a rather large excel sheet (56,00o rows x 12 columns)
I want to extract just the rows (12 columns wide) that contain certain keywords/phrases.

I want t search for "Work" and only have those rows where "work" appears to remain.

Is something like this possible?

 

[yinan]

You could do this with a vbscript. Not the most efficient way, but you can do it.

I would recommend converting it to a database for much easier user in the future.

 

[stlcardinals]

Or you could just turn the whole sheet into a table with headers and use filtering.

 

[Binky]

Are you saying that you want to seach every row for ANY occurrance of "work", or you have a specific column where the cell value may be "work"?