ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Pivot Criteria Capture (https://www.excelbanter.com/excel-programming/387696-pivot-criteria-capture.html)

Michael Conroy

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