Young Fang
New Member
I want to search/find "fire" or "combustion" or "ignition" in column C. the entries at every row of column c are sentences, not just a word (which is relatively easier).
Once "fire" or "combustion" or "ignition" could be found, then copy the entire row (entire columns or selective columns) and transfer the data to the other workbook or mater workbook.
My question is: how to find a word (fire, combustion,ignition) in a sentence in a cell? removing duplicate (data validation) may be needed after searching.