Using a Single Command Button to Apply Filter and remove filter

manojsahooin

New Member
Joined
Jan 3, 2014
Messages
25
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
 

Some videos you may like

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

EPURON

Board Regular
Joined
Nov 5, 2013
Messages
123
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

New Member
Joined
Jan 3, 2014
Messages
25
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
 

Watch MrExcel Video

Forum statistics

Threads
1,122,670
Messages
5,597,483
Members
414,146
Latest member
marginmakerb

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top