Lucas,
Actually, the implementation of the AdvancedFilter feature in the VBA code will definitely resolve your problem. The main advantage of using this feature is the absence of the loop, which means the increase in the macro execution speed.
The procedure for the solution may consist of the...
