View Single Post
 
Old 08-08-2022, 02:37 PM
kilroyscarnival kilroyscarnival is offline Windows 10 Office 2021
Expert
 
Join Date: May 2019
Posts: 344
kilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nice
Default

Quote:
Originally Posted by JHalter View Post
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
Reply With Quote