Using Conditional Formatting (key word) to identify row and export to new sheet.

Hi All,

I really hope some genius can help me.

Excel in Office 365.

I have a spreadsheet that contains an array of data (column A-Q and row 2-10,000)

The data that I have is generated from 34 sheets within the spreadsheet (I have converted each sheet into a table) and have been collated all of the data on one sheet using a query.

The data that I'm interest in is located in Column E which contains the general descriptions of the product. I have set up condition formatting that responds to key words i.e hat, beanie, etc, which highlights the cell green.

what I want to do is extract the entire row (A-Q) when the conditional formatting is triggered for a key word and export the entire row into a new sheet named "headwear".

In the future I want to be able to set up separate sheets for different categories such "outerwear", "accessories", etc.


The issue I have is the descriptions coming in (located in column E) are not a one word categorization 'beanie' they are more of a sentence / paragraph, an example would be.

"Hi thank you for your time, I have an issue with the beanie that I bought a couple weeks ago the tread is coming loose, could I please arrange a replacement"

As a result I want to be able to identify the word 'beanie' from the text and then export the row it is associated with into a separate sheet, much like a filter.

Is this possible and if it is can someone please help me out

Joach

Hi Ali,

That would be great.

Thanks in advance

Joach