Forum Discussion
Help with Macro (new to macro's)
I'm not a macro person, so if you're absolutely committed to doing this, you're going to have to wait for somebody else to come along.
But I did want to chime in just to say that macros and Visual Basic routines are often overrated. I say that because the built in functions of Excel have continually been extended over the years, often now able to do things that required macros/VBA in the olden days. I know there are other "experts" here at this site who work first to find a non-macro solution if it's at all possible.
So if you don't mind describing the actual situation a bit more, or letting us know that you've tried--say--the FILTER function and found it wanting for this or that reason, it's conceivable that somebody here might be able to help you find a different solution.
If you're just wanting to learn how to write a macro...go for it, and feel free to ignore my comments. 🙂