I have a workbook with a sheet that has data in 3 columns. One column contains a string, and I would like to move every row with a value for that third column to another worksheet. How would I do that?
Welcome!
Just use filter
Choose Data - More Filters - Standard Filter
Set the condition “The value in this column is equal to this string”
Expand the Options block and check “Copy results to…” and select a cell on the second sheet.
Click OK
2 Likes