Forum Discussion
Moving rows to another sheet based on several keywords
Hello, I am working with a database of User accounts that include human and non human users. I am trying to separate a select set of users into another sheet as they will be processed differently tha...
Depending on what version of Excel you're working with, it might well be possible to do what you're seeking to do without a VBA routine. The most recent version has a number of Dynamic Array functions that can FILTER (that's one of them) a data table according to criteria and give you just the rows that meet your criteria.
One of us here could demonstrate that, but we'd need to work with a representative sample of your actual worksheet---just remove any real names and other identifiable data.