Good morning.

Trying to avoid code, I attempted to filter rows in my document where one specific column may contain a certain word. I can use the find function to return all instances of this word and be given the cell references. When I highlight this list in the advanced find the cells in the document highlight.
Going back to the document I cannot work out how to extract the entire row of information for each instance.

Shift + Spacebar just selects the row of one of the highlighted cells.

Is there a simple command to select or filter the row so that I can copy the information to another spreadsheet?

Thank you.