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
|