Hi, involved in a project which requires multiple Worksheets to be consolidated - up to 20 worksheets, there could be a mixture of consolidating 3, 6, or more worksheets are anyone time.
We do not want to set the worksheets up in different workbooks, which would solve the issue (see below) but would create more work long term.
The issue is that when the Groups are expanded the 'Region' as workbook shows for the Import total, only shows the File Name and not the Sheet Name eg Central, West, East etc.
Can this be done without using VBA? Otherwise it is a manual fix. Am sure some clever bunny out there is able to do this! Many thanks in anticipation!
We do not want to set the worksheets up in different workbooks, which would solve the issue (see below) but would create more work long term.
The issue is that when the Groups are expanded the 'Region' as workbook shows for the Import total, only shows the File Name and not the Sheet Name eg Central, West, East etc.
Can this be done without using VBA? Otherwise it is a manual fix. Am sure some clever bunny out there is able to do this! Many thanks in anticipation!