+ Reply to Thread
Results 1 to 2 of 2

Slicer Alternative

  1. #1
    Registered User
    Join Date
    04-26-2016
    Location
    Minneapolis
    MS-Off Ver
    2013
    Posts
    21

    Slicer Alternative

    I have a table, and I have defined named ranges. My data sources is one sheet1 which has headers; I would ultimately like to use data validation on sheet2 - so I would have each header listed and have a drop down with distinct values (from the data source in sheet1). The trouble I am having is for the filters to actually work and filter the data. In a sense, I am trying to do what the little filter arrows would do on sheet 2.

    I have tried advanced filtering, and even using INDIRECT as part of the source in the data validation - but I might not be using it correctly

    I do realize there are slicers that do this method, but I keep getting this slicer cache error when opening up the document and can't figure out why.

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,407

    Re: Slicer Alternative

    It's difficult to figure out from the description what is going on. A sample workbook will help us visualize the issue more clearly.

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

+ 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. Lop through slicer until end
    By 3345james in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-19-2015, 09:35 PM
  2. Can I Sync a Slicer to Another Slicer If....
    By Polak in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-04-2015, 12:35 AM
  3. Make one slicer mirror filters of another slicer
    By IbenezPrez in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-28-2014, 02:00 PM
  4. how use slicer
    By Dadvar2 in forum Excel General
    Replies: 3
    Last Post: 09-05-2013, 08:29 AM
  5. 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
  6. [SOLVED] Change Chart Title Depending on a Slicer - slicer advice
    By JungleJme in forum Excel General
    Replies: 8
    Last Post: 08-17-2012, 07:59 AM
  7. Slicer Help
    By kianhui.lim in forum Excel General
    Replies: 1
    Last Post: 03-12-2012, 12:14 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