+ Reply to Thread
Results 1 to 2 of 2

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

  1. 12-19-2012, 04:33 AM #1
    FixandFoxi
    FixandFoxi is offline
    Registered User
    Join Date
    06-06-2012
    Location
    Switzerland
    MS-Off Ver
    MS Excel 365
    Posts
    68

    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
    Reply With QuoteRegister To Reply
  2. 12-19-2012, 10:19 AM #2
    FixandFoxi
    FixandFoxi is offline
    Registered User
    Join Date
    06-06-2012
    Location
    Switzerland
    MS-Off Ver
    MS Excel 365
    Posts
    68

    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 With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1