+ Reply to Thread
Results 1 to 2 of 2

Synchronising slicers with different source data

  1. #1
    Registered User
    Join Date
    04-01-2013
    Location
    Melbourne
    MS-Off Ver
    Excel 2007
    Posts
    4

    Synchronising slicers with different source data

    I was hoping someone could help me with some coding.

    I'm creating a Sales vs Quotes dashboard which has two different data sources. I'm trying to get the selections of multiple 'Master' Slicers (in blue) to synchronise the same selection on their corresponding 'Slave' Slicer (in green). The value selected will change the sales data in the top 2/3rds of the dashboard, and the quote data in the bottom 3rd of the dashboard.

    So far I've managed to find a code which performs the synchronisation for one of the slicers (Week), but I have no idea how to continue the code for all Slicers on the page.

    Regards,
    Burger

    Example.xlsm

  2. #2
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Synchronising slicers with different source data

    while it can be done its not easy synchronising slicers with different sources

    would be far easier to combine both sources into one and use that as your dashboard data
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

+ 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] Disconnect Slicers, Change Pivot Table Source, Reconnect Slicers: a problem
    By Geoff. in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-30-2015, 02:27 PM
  2. Replies: 0
    Last Post: 11-12-2014, 08:39 AM
  3. Synchronising Combo boxes vba
    By blh in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-28-2014, 12:46 PM
  4. Synchronising cells using VBA
    By Skins11 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-08-2014, 08:04 PM
  5. [SOLVED] Synchronising data being referenced dependent on a non zero value
    By RupertC in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-26-2012, 03:35 AM
  6. synchronising combo boxes
    By Vetequk in forum Excel General
    Replies: 2
    Last Post: 02-02-2009, 03:41 PM
  7. synchronising pivot tables
    By Johngio in forum Excel General
    Replies: 1
    Last Post: 07-31-2006, 09:08 AM

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