+ Reply to Thread
Results 1 to 3 of 3

Can you move a filter button on a table to another sheet?

  1. #1
    Registered User
    Join Date
    09-18-2014
    Location
    Los Angeles, CA
    MS-Off Ver
    2013
    Posts
    33

    Can you move a filter button on a table to another sheet?

    I have created a slicer on a table (not a pivot table), and I am displaying the slicer on a dashboard sheet along with some graphs, etc.

    I would like to have a search feature on the slicer. The easiest solution I can think of would be to move the filter button on the field I am slicing from the table to the dashboard sheet. Is this possible?

    Any alternative solutions would be greatly appreciated.

  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: Can you move a filter button on a table to another sheet?

    Hi

    Can you clarify the point about moving the filter button and what a search feature on a slicer would do or look like. I'm struggling to understand what you're getting at.
    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
    09-18-2014
    Location
    Los Angeles, CA
    MS-Off Ver
    2013
    Posts
    33

    Re: Can you move a filter button on a table to another sheet?

    Hi Rich, thanks for the reply, and sorry if I wasn't clear.

    I hope this picture helps, I basically want to put a search feature on a slicer, and I felt like the easiest way would be to move the red circle in sheet 1 to the red circle in sheet 2.

    Thanks!DescPic.jpg

+ 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. Excel Macro - Filter button activate on both sheet if activated on one sheet
    By umeshbanga in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-26-2014, 02:22 PM
  2. Move button to another sheet
    By TRLWNC in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-20-2014, 11:54 AM
  3. How can i print filter report or move to new workbook by click command button
    By Nisar.mohammed in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-17-2014, 09:01 AM
  4. Move data from Sheet 1 to Sheet 2 based on critera like adv filter?
    By gspivey79 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-02-2012, 12:45 PM
  5. [SOLVED] Create a button to move to next sheet?
    By VACaver in forum Excel General
    Replies: 7
    Last Post: 07-29-2012, 09:03 AM
  6. Auto filter then move subtotal to another sheet
    By tony0710 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-25-2009, 06:50 PM
  7. VBA - button to move to another sheet to same cell
    By baz0912 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-09-2008, 11:21 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