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