Macro to Group Rows with Zeros in Multiple Columns

I've search multiple posts trying to find this solution only to have the code not work for me. I've found several posts that group/hide and have tried to tweak the macro to work for me, but I'm just not that familiar with these commands and am having no luck.
I have a workbook with multiple sheets for financial reporting each with multiple columns for months/year-to-date info. All of the sheets pull data from another master sheet within the workbook and then each sheet is consolidated to another sheet. Some of the sheets have rows which contain all zeros. I'd like to create a macro that will first ungroup/unhide all rows, then group (or hide) all rows that contain zeros in all of the data columns. I'd like to run the macro and have it perform this action on all of the sheets except the master sheets.
Attached is an example of the workbook. The master data is exported from a financial program and pasted into the master worksheets. The data from the master sheets flow to each individual sheet and to the consolidated. Any help would be greatly appreciated!


ZeroRows.xlsm

Thanks for the reply! This spreadsheet will be updated each month and there may be rows that contain non-zero values that were previously hidden. I figured if I unhide/ungroup all of the rows first, that would take care of them when we did the re-hide/re-group. I'm open to suggestions!

Anybody have any thoughts on a solution for this macro? Any help would be appreciated!

The click of a button would be perfect!

I use this code to auto group based on columns being 0 (only if all columns = 0

Please Login or Register  to view this content.

i over thought the process try this:

Please Login or Register  to view this content.

you can add it to a macro triggered by a button, it currently just does it for the selected sheet but you could do it for all non control sheets

Yeah, didn't think about that ill see what I can figure out to resolve that