Results 1 to 1 of 1
  1. #1
    Star Lounger
    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?

    File attached
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts