Forum Discussion
Automated filters
Hi everyone, I have a table with muliple columns all with filters. I would like to create few "buttons" from which you could you click on it and it would filtered each column like I decided (ex: ...
Deleted hello there.
Yes, you would need VBA for this. Best way to do so is to record a macro of you clearing and setting the filters to what you want. You can always post the code here to help get it cleaned up.
Note: if you need to show the Developer tab and it's not, right click anywhere on the ribbon and select "Customize the Ribbon...", and on the right list box check the box next to "Developer" and hit OK. Click the Developer tab and "Record Macro" to begin.
HTH