Efficiency issue when looping through each cell

Originally Posted by royUK

AutoFilter would be much faster than a Loop

Could you elaborate a little on how that could be done in this example?