If you can mark the row's of interest by inserting a value in an empty column for each row, then you can use autofilter to view only those rows that are marked.

You can then also, if desired, copy and paste just those rows elsewhere.