Originally Posted by Paul_Hossler What I've done in the past was to use a macro to write each page field's (e.g. Department) filtered pivot table data to a separate workbook as just their data. Actually I'd be interested in that- do you have the code for it?
Forum Rules