I have one sheet named “raw” with several thousand rows of data. I would like to copy all rows with the text “abc” into another sheet using a function (rather than Edit/Find&Replace).
Not needed find & replace, if data are organized like a table, Menu/Data/More Filters - Standar filter can be customized to have a range where to copy the filter selection.
Also there is an extension Copy only visible cells, that makes easy to copy filtered rows with ‘Autofiler’