What's the best way to automatically search for and delete rows that have a certain value in a field? For example, in a spreadsheet, I want to find all the lines that have "x" in a field and delete them from the spreadsheet.
Also, is there a way to extract certain data and create separate worksheets? For example, each different sales person code should be on a different worksheet; all are on one currently.
Also, is there a way to extract certain data and create separate worksheets? For example, each different sales person code should be on a different worksheet; all are on one currently.