Advance filter help

[Svmaxcel]

I have data in my sheet, I made VBA to do advance filters.

Everything seems to work, but when I make selection in filter that doesn't work.
Please check attached file

[mana]

>I made VBA to do advance filters.

Where is your code?

[p45cal]

Seems fine here. Attached is your file with buttons to Advanced Filter to multiple locations and in-place.




when I make selection in filter that doesn't workI don't know what this means.

[Svmaxcel]

File attached

[p45cal]

I can't make head nor tail what you want to do/happen from your most recent attachment.
No VBA. No intention.
Nothing.
Attached… who knows?

[Svmaxcel]

My bad, I saved the file as a non macro file.
Sorry about that, I just created an example file.
If you see thus file, even manual advance filter is not working.
I have data from A1 to H12.(F,G,H are formulated)
I copied pasted all headers in A18:H18
I have mentioned some filters in G19 and H19
When I run advance filter the list is not getting filtered as per the critetia

[p45cal]

See file attached to msg#5

[Svmaxcel]

Checked attached file, I am not able to understand why is it not working in the file I updated.
Forget about VBA but manual advance filter also not working

[p45cal]

Did you make sure that the Criteria Range was Data!$A$18:$H$19 rather than Data!$A$18:$H$20?