Ask Your Question

Copy Some Rows to a New Sheet if Text Exists

asked 2018-01-21 21:53:40 +0100

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).

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2018-01-21 21:59:24 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

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'

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-01-21 21:53:40 +0100

Seen: 79 times

Last updated: Jan 21 '18