I'd like to select entire rows based on rules.
- How would I select all the rows where column A is greater than 3?
- How would I select all rows which contain a string in Column A (string could be anywhere in the cell)?
I plan to select rows based on rules and then copy them into a new sheet, deleting empty rows after that.
I was hoping to do this without using VBA.