Filter - Just like Access

[Madiya]

Hi,
I am always working with huge lists of data where I use autofilter
regularly.
Here I would like to have a macro which helps me quickly use filter
with right click - just like in the MS Access. Also I want to apply
filter without removing previous filters.
Is it possible to have such macro? May be in personal macro book?

Please guide a way forward.

Regards,
Madiya

 

[Madiya]

My deepest apologies, I just realized I was thinking of the filtering in
/pivot tables/, not Excel's autofilter. Please disregard my comments.- Hide quoted text -

- Show quoted text -

Yes, generally but not always.
And Sure I am thinking about excel's autofilter.
You surly gave your time for my problem and thanks for that.
I hope some expert here will help me.

Regards,
Madiya