Advanced filter used frequently slows down workbook?

[oblix]

I have been using advanced filters for copy and paste in vba
these filters must run frequently (at least 15 imes daily before saving for next day
I have watched a video that explained that advanced filter used many times after each other slows down workbook.
Is there a way I can clean up and speed up vba/workbook if this happens?
Maybe a vba script or addin?

 

[JEC]

Then you should work with arrays icw loops.
If you post some sample data and desired outputs, I am sure you will get a nice solution

 

[oblix]

Thank you for reply
Will get to work on samples as soon as possible
Is arrays and loops not going to slow down large data sets?

 

[Peter_SSs]

Is arrays and loops not going to slow down large data sets?

It depends on what your exact circumstances and requirements are

 

[oblix]

If anybody would be prepared to receive my whole workbook with all code and have alook....
then we could paste in forum what I did and what was changed to improve it...would that help?
I will gladly email to someone

 

[Peter_SSs]

As per the text & intent of #4 of the Forum Rules we prefer for everything to remain in the public domain.

You can post any code directly in the forum (use code tags as indicated in my signature block below) and post small sample data directly in the forum using XL2BB

Alternatively, you can upload your sample workbook to somewhere like DropBox, OneDrive etc and provide a public link to that file here in the forum. A consideration with that method though is that many of the experienced helpers here choose not to download files from other sites or, due to security restrictions at workplaces, are unable to download such files.