+ Reply to Thread
Results 1 to 6 of 6

Linking Slicers from Different Sources

  1. #1
    Registered User
    Join Date
    04-20-2015
    Location
    USA
    MS-Off Ver
    2010
    Posts
    51

    Linking Slicers from Different Sources

    Hello all,

    I was hoping there was a code somewhere that would link multiple slicers from different data sources. I am trying to get it so that by clicking on one person's name, it changes all the slicers to reflect that same name. I have 6 different sheets for a dashboard being driven by 6 different data sources, but all the names are in a column called "Sales Name" and all have the same name format. I can put together a dummy version if it will help but wondering if there is a similar macro that has already been created.

  2. #2
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: Linking Slicers from Different Sources

    Are they different data sources?
    Please ensure you mark your thread as Solved once it is. Click here to see how.
    If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.

  3. #3
    Registered User
    Join Date
    04-20-2015
    Location
    USA
    MS-Off Ver
    2010
    Posts
    51

    Re: Linking Slicers from Different Sources

    Yes, all with the same column name with the names in the same format so all the slicers (5 total) have the same data in the same list. Trying to prevent people having to select the same name for all 5 slicers and instead only having to select 1.

  4. #4
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: Linking Slicers from Different Sources

    Why not build all the pivot tables off ONE data source then ONE slicer can be used to control them all?

  5. #5
    Registered User
    Join Date
    04-20-2015
    Location
    USA
    MS-Off Ver
    2010
    Posts
    51

    Re: Linking Slicers from Different Sources

    Because they are very different material but share one linking factor, the sales person's name. I am trying to figure it out for to control the dashboard.

  6. #6
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: Linking Slicers from Different Sources

    h, well in the past I started going down this EXACT path, and ended up putting all of the data into PowerPivot and then just using one slicer because dealing with the VBA got proper annoying, so good luck to you.

+ 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. Slicers to sync multiple pivots from multiple data sources?
    By cantona_lives in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 06-21-2017, 12:33 PM
  2. Linking Slicers to show different years using VBA Code
    By rv02 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-18-2015, 07:06 AM
  3. Synchronize Slicers with multiple data sources
    By dkjhn in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-22-2015, 02:56 PM
  4. Linking data from various sources-macro help?
    By Dan1987 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-21-2014, 09:13 AM
  5. Linking Chart Data Sources
    By samprince in forum Excel General
    Replies: 1
    Last Post: 01-09-2007, 09:45 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