Advanced Filtering, variable criteria range

[Handkerchief]

Hello everyone.

I'm trying to filter a table based on a criteria and copy&paste the result to a different sheet.

Basically I have a huge amount of data stored in one sheet("Department ERP") and I need to filter column("GLO_MASS_LINE") based on a criteria, then copy&paste each of the results to a different sheet.

Since AutoFilter and subsequent copy&paste option is too slow, I decided to go for Advanced Filtering. I prepared a huge range of sheets (from sheets 11 to 38), where I want to put details for specific costs (for example, I want to filter the table stored in "Department ERP") for Employee education and copy&paste the result into sheet("EDUC") = sheet no. 11), then I want to filter "Events/Relationship marketing" and copy&paste the result to sheet("ERMA"), etc etc...)

So far, I have this code:

Please Login or Register  to view this content.

The problem I am now facing is that the code loops through sheets and filters the data, but only for the first criteria (the criteria is still the first one "Employee education").

Would you help me find the problem here? Any help would be highly appreciated.

Thank you.

[Sintek]

Hallo Handkerchief

Welcome to the Forum...
In future please be so kind and read the forum rules...here
Your post does not comply with rule #2
2. Programming code must be enclosed in code tags to improve readability. (A, Z)

Please Login or Register  to view this content.

Unfortunately no help can be offered until this is rectified...
Edit your post above...Highlight your code and press the # button

Also..Unfortunately images do not explain your requirement...Upload a sample file depicting a before | after expected result...

[Sintek]

Thank you...Appreciated...How bout a sample upload...