Grouping results using MultiSheet Consolidation

**scottb** · 08-02-2010, 06:12 AM

Within the example workbook, I want the country results in 'GlobalSummary' to be broken down into Groups. Groups will be driven by each worksheet.

As you will see, each worksheet is a country, so the groups will be as per the 'Results Required' worksheet example.

I hope this makes sense and is possible - thanks for any help as I have no idea how to do this.

**JBeaucaire** · 08-02-2010, 12:06 PM

Just a variation on the first macro:

Please Login or Register  to view this content.

**scottb** · 08-21-2010, 07:20 PM

Thank you! - Works a treat

Is it possible to do a 'Show all' (every month) option within 'INTLsummary'

**scottb** · 08-26-2010, 05:49 PM

Can anyone figure out how to alter the macro so that I can 'show all months', as well as each month?

If the marco has to be altered so that I cannot show individual months, then i will accept this.

Thanks,

**JBeaucaire** · 08-26-2010, 07:48 PM

I added an "ALL" option to your drop down for the months (at the top of the list). Select that and run the macro for each page. Both macros have been edited to allow for collecting all data instead of filtering.