+ Reply to Thread
Results 1 to 4 of 4

Need Slicer Selection to Appear in a Cell

  1. #1
    Registered User
    Join Date
    01-11-2017
    Location
    Boston, MA
    MS-Off Ver
    2013
    Posts
    10

    Need Slicer Selection to Appear in a Cell

    I have a pivot table generating a slicer called "Slicer_Lag2". I need the value selected in the slicer to be displayed in a normal cell for use in a separate formula. Does anyone have a solution for me? Thanks!

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Need Slicer Selection to Appear in a Cell

    Hi and welcome to the forum.

    You could put the field in question also in the Report Filter area of the field list so that it appears in the row a couple of rows above the PT. Then simply link your formula cell to that PT cell.

    There's no doubt some VBA code that could interrogate the slicer and do it but the solution above is probably the simplest.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    01-11-2017
    Location
    Boston, MA
    MS-Off Ver
    2013
    Posts
    10

    Re: Need Slicer Selection to Appear in a Cell

    Hi Richard, thanks for the quick reply. Unfortunately, I can't include this as a field in the pivot table because I do not want the field to appear in my linked pivot chart. If you have a way around this, I am all ears!

  4. #4
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Need Slicer Selection to Appear in a Cell

    Hi,

    Put the following procedure in the Sheet Calculate event. Change the ref. to A1 as appropriate

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Macro to Run when Slicer Selection is Changed
    By MBeedle in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-28-2017, 09:29 AM
  2. Slicer Selection - Column Highlight
    By Shadyyacout in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-15-2016, 04:38 PM
  3. Slicer Selection loop is very slow!
    By barowan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-04-2016, 10:09 AM
  4. [SOLVED] Run Macro when slicer selection changes
    By Pony08 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-05-2016, 06:26 PM
  5. Have a cell equal to a selection in a slicer?
    By qlikview in forum Excel General
    Replies: 1
    Last Post: 07-07-2015, 03:00 PM
  6. Limiting Slicer multiple selection
    By Paul-NYS in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 12-17-2012, 02:58 PM
  7. Slicer Macro - unfilter another slicer on selection
    By chadheins in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-24-2012, 10:41 AM

Tags for this Thread

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