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!
Bookmarks