Results 1 to 1 of 1
2011-10-13, 09:10 #1
- Join Date
- Nov 2008
- England, Yate, Bristol
- Thanked 0 Times in 0 Posts
Excel 2010 - show (PivotTable) report filter pages
I have created a pivot table and click Options - Options - Show report filter pages.
This works admirably except that the final page is always named Sheet11 or whatever the last number of sheets is, whether filter pages are 7 or 11 the last sheet is always call by its sheet number and not by the filtered sheet name.
I then search through each sheet looking for every worksheet name except Sheet1 or Sheet2 and run some code.
How can I get this last filtered sheet with the filtered sheet name please?