Hi All
I am desperately looking for a Macro that would allow me with the click of a button to go through all the sheets of my workbook and do the following to every sheet:
- ungroup columns and row
- unfilter
- refresh
- re filter
- re group
from the first sheet after the sheet that contains my button until the end and then to go back by refreshing every single sheet. I would like avoid to record a macro as I have many sheets in my workbook and it becomes too heavy.
any help would be greatly appreciated
I am desperately looking for a Macro that would allow me with the click of a button to go through all the sheets of my workbook and do the following to every sheet:
- ungroup columns and row
- unfilter
- refresh
- re filter
- re group
from the first sheet after the sheet that contains my button until the end and then to go back by refreshing every single sheet. I would like avoid to record a macro as I have many sheets in my workbook and it becomes too heavy.
any help would be greatly appreciated
