Good afternoon to all!
I would like to know a formula to check in a column a particular word,
should find the entire contents of the line should be moved to another
spreadsheet.

If you know someone kindly help.