Quote:
Originally Posted by JHalter
I want to move entire rows to a new tab that contains certain text. How do I set this up without having to copy/paste all the rows containing the certain text?
|
I think it says you have Excel 2021, so you might have access to the FILTER function.
I got to play with this last year to do the same sort of thing. It pulls info to various tabs based on whether the text in the first column contains a specific letter pertaining to that division of the company. From there I specified which columns to copy and in which order. I'm not sure I used it recently enough to do without looking up the steps, but:
FILTER function