filter base on cell values

[aravindhan_31]

I have 2 sheets Input and MacroSheet, I paste my raw data in input sheet.
on my macrosheet, I enter the values in A2,B2,C2 for filtering the data in put sheet.

I have this code..

Please Login or Register  to view this content.

when I run the above code, nothing happens, neither I get result nor error.. Don’t know where I am goinng wrong..
I have attached the my file...

[Wizz]

Aravindhan_31,

You have to remove the ".Autofilter" line. if you run your code with F8 (line by line) and bypass the ".ScreenUpdating=False" you'll see that you are filtering and defiltering.

Please Login or Register  to view this content.