Hi all,
I was hoping someone could help me with some loop code for below consolidation macro.
My workbook has a "Consolidation" tab and several country tabs (all same format). My code consolidates all of the individual country tabs (after a filter is applied), one below the other in the consolidation tab.
Below code works for 2 countries but there will be 20+ country tabs.
I'm hoping someone can tweak my code so it can loop through all the country tabs rather than having to duplicate the code over and over like below.
Please Login or Register to view this content.
Bookmarks