Quote Originally Posted by photom View Post
Is this possible with VBA? Can anyone be so kind and give me a hand?
Hi,

yes with exactly the same way any Excel user operating manually in less than ten seconds !
Just using a filter, under VBA reproducing this way should need less than ten codelines,
instant result, looping is useless, easy to start yourself just activating the Macro Recorder …