Efficiency issue when looping through each cell

Originally Posted by royUK

Would it be possible to filter the data using AutoFilter?

Possibly, but I do not see an immediate gain from doing that. What are you thinking?