Using a Single Command Button to Apply Filter and remove filter

[manojsahooin]

Dear Team

I am needing a help!

How can i use a single command button to do multiple task in Excel 2010.

First Instance I click -- It filters only With Record "Yes"
Second Instance I click -- It filters only With Record "No"
Third Instance I click -- It removes filter.

Appreciate your early response in this Regard

Thanks & Regards
Manoj

 

[EPURON]

What you can do is record a macro for the 3 instances. Then put all that code together in a sub on a macro and assign a button to the macro

 

[manojsahooin]

Hi Epuron

I am not so good at this, could you tell me how to pull all three macro to one command button.


thanks
Manoj

 

[manojsahooin]

Hi Team

Can any one help me on this.

KR