Active Member
October 9, 2024
Hi, is there a simple way to set something up where a button or similar can be setup which will on click, clear filters and re-group data to its rolled up groupings?
The groupings are already set, its just that there is a large data set which is used frequently in ungrouping (opening) and re-grouping (closing) ; as well as filtering.
It will be a large time saving if I could setup a button which i can click and take me back to the "starting view" to then work on the next filter/group combo to provide data on.Hope this makes sense...
Trusted Members
October 17, 2018
If you can do it manually ... then you could also do it with a macro.
Start the macro recorder and record every step you do until you reach the desired result.
Stop the macro recorder and take a look with the VBA editor what it looks like ... then you can adapt the macro to do much more by editing and customizing.
This of course, if you want to use macro's
Answers Post