I have a workbook containing a number of tabs, one for each week, increasing as the weeks go by. The tabs are reverse dated from each Monday, e.g. 20220829.
Each tab has a single table that is summarising the seven other daily tables on the worksheet. This summary table is in range A100:E422.
On a separate pivot tab is an analysis of this summary data. What I would like some help with please – if it’s possible – is to understand:
(1) if I can create a dropdown menu of some fashion to instruct the pivot to draw its source data from a particular tab and refresh (rather than going through the Change Pivot Table Data Source);
(2) for extra brilliant points, if something like a dropdown or other is possible, how to ensure that other (yet to be added) tabs are picked up as an option when they are added to the workbook.
Many thanks all.
Each tab has a single table that is summarising the seven other daily tables on the worksheet. This summary table is in range A100:E422.
On a separate pivot tab is an analysis of this summary data. What I would like some help with please – if it’s possible – is to understand:
(1) if I can create a dropdown menu of some fashion to instruct the pivot to draw its source data from a particular tab and refresh (rather than going through the Change Pivot Table Data Source);
(2) for extra brilliant points, if something like a dropdown or other is possible, how to ensure that other (yet to be added) tabs are picked up as an option when they are added to the workbook.
Many thanks all.