"Tom Ogilvy" wrote:
The advanced filter does this in one command. You would
be well served to use the power that is inherent in Excel.

I agree. Thanks for the pointer. I will see if it does the job.
(Frankly, I would be very pleasantly surprised.)

Even if learning VBA, is isn't usually useful to reinvent the wheel.

I strongly disagree. Back when I took CS 1 (et al) 38 years
ago, that is exactly how we learned programming. I cannot
imagine that things have changed. In fact, to that end, I will
continue to learn a VBA solution just, if only for my edification
about VBA. It has already been very educational.

So I hope that others will be kind enough to continue discussion
in this thread. I no longer need a solution -- I think I have a
handle on it. But I am sure that I will have questions about
this-and-that alternative programming.

TIA.