I use the search and get an excellent result. Hundreds of hits extracting from the sheet just what I want. But it won’t let me do anything with the hitlist except look at it. I thought i would be able to paste it into a spreadsheet but i can’t.
Is there are way?
Check “filter”, also in menue Data.
.
The output of a filter can be directed to another sheet/area.
.
I created my first “advanced” filter with help of this page (german and only available as archived version):
https://web.archive.org/web/20200212014126/http://www.ooowiki.de/SpezialFilter.html
Looking at isn’t everything you can do.
Supposing you used F&R (now Ctrl+H), and your “hitlist” is the Search Results display, you can select any single match there, get the cell highlighted by that, and edit it if required. You then can proceed with a different finding.
The Find All oiriginally selects all the matching cells, but since this selection generally is not a contiguous SheetCellRange, you can’t use Copy / Paste with it. That’s how multiselections generally are treated, and of course there are valid reasons. The only somehow reasonable exception might be to allow a special kind of CopyMany, and a PasteIntoNewSheet then.
So far the explanations. Now the suggestion
If urgently needed, you can implement this CopyMany / PasteIntoNewSheet writing user code.