+ Reply to Thread
Results 1 to 2 of 2

Pivot Report Filter - Readout/Display selected items in a cell

  1. #1
    Registered User
    Join Date
    06-06-2012
    Location
    Switzerland
    MS-Off Ver
    Excel 2007
    Posts
    66

    Pivot Report Filter - Readout/Display selected items in a cell

    Hi!

    I tried to find an answer in different treads but without any lucků

    Please see attached Excel file. I have a pivot table with a report filter. Now, when more than one item is selected, the report filter shows (Multiple Items). Is it possible (with VBA) to write/readout/display the selected items in a cell next to the pivot table (see cell E1, this is what I am looking for)?

    Many thanks for your inputs!

    Best regards,
    FixandFoxi
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    06-06-2012
    Location
    Switzerland
    MS-Off Ver
    Excel 2007
    Posts
    66

    Re: Pivot Report Filter - Readout/Display selected items in a cell

    I found this working code but instead showing the selected items in a message box, the items should be written as a text string in a cell. Can somebody held me? Many thanks!

    Please Login or Register  to view this content.
    Last edited by FixandFoxi; 12-19-2012 at 10:21 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1