Search cell content for particular word, if found copy row

[spectraflame]

I have imported a text file into Excel. Column B contains a text string that varies in lengh from blank up to 50 characters. I need to be able to search the values in that column and copy the entire row to another sheet within the same workbook if the cell contains the word REMOTE.

Is this possible?

Thanks,
Matthew

 

[Bucsfan]

Hello - Need some assistance in creating a formula or macro that is similiar to the above questions....

I need to search for the word "Wax" in column C of sheet 1 and if it is found, I need to copy that entire row onto sheet 2, starting in cell A1. The word "Wax" will likely appear many times on sheet, so each time it appears I need it to copy on sheet two in the next row.

Thank you to whoever can help!!

 

[Norie]

Can you start a new thread for your question?

I think people might be a little reluctant to read through the original.

 

[Bucsfan]

No problem!