Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 2 of 2

Thread: Change Slicer Selection based on Cell Input

  1. #1
    Join Date
    27th June 2012
    Posts
    1

    Change Slicer Selection based on Cell Input

    I would like to be able to change what is selected in my slicer based on a particular cell value.

    For example, if my slicer contains the names of hundreds of sales reps, I would like to be able to type the name "John Brown" into cell A3 and have this automatically select "John Brown" in the slicer.


    Thank you very much!

    Hank

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    28th October 2010
    Posts
    832

    Re: Change Slicer Selection based on Cell Input

    Excel 2010 Table, PivotTable, Slicer
    Populate Slicer with item(s) put into a Table.
    http://c3017412.r12.cf0.rackcdn.com/02_08_11.xlsm
    If you get *.zip, don't unzip, just rename *.xlsm

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. How to copy Slicer selection to a cell in Excel 2010
    By crosshairs308 in forum EXCEL HELP
    Replies: 5
    Last Post: February 11th, 2012, 00:38
  2. Replies: 4
    Last Post: July 29th, 2010, 15:44
  3. Replies: 1
    Last Post: January 22nd, 2008, 09:57
  4. Replies: 2
    Last Post: March 24th, 2007, 04:36
  5. Replies: 2
    Last Post: June 26th, 2003, 00:56

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
  •  
porno