Select ALL Rows With Certain Keywords

Hello Everyone!

I'm having trouble and was wondering if you could help.

Using Excel 2007.

I have 10 .xls Files, each with 4 FULL spreadsheets, with over 2GB of data.
Was wondering if there is way to copy certain rows that contain specific keywords.

For example: all rows that have the word "green" in them and all rows that have the word "blue" and so on.

I tries using search function (CTRL+F) and used "Find All" option. It did find all the occurrences. When I selected all the findings it limited selections to specific CELLs now the ROWs.

I was wondering if there is a way to select ROWs with specific KEYWORDS in them.

Thank you!

Hi, and welcome to the forum.

Just use the standard Data Auto Filter functionality, picking the values you want from the appropriate drop down arrows in the column labels. Once filtered select all the rows and copy/paste them wherever you want.

Rgds

Set auto filters, in the column where the values are click on the filter, the drop down menu of the filter will give you sort a to z, z to a etc and the last option is "text filters" and then other menu opens and select "starts with" or "contains", that will give you the rows containing those words.

Hope this helps.