![]() |
Pivot Criteria Capture
I use three criteria to filter the pivot table: region, quarter and year. I
would like to capture quarter and year, concatenate that into a cell and reference that cell in the page header. This way I will know what data is being printed out. If this can't be done, could someone at least remind me how to reference a cell in the header so I can have dynamic referencing there. Any help would be appreciated. Thanks. -- Michael Conroy Stamford, CT |
All times are GMT +1. The time now is 10:38 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com