+ Reply to Thread
Results 1 to 3 of 3

How to connect slicers from different source of data, VBA code

  1. #1
    Registered User
    Join Date
    04-17-2016
    Location
    Bern
    MS-Off Ver
    Excel
    Posts
    1

    Red face How to connect slicers from different source of data, VBA code

    Hi everyone,

    I am working on a project where I need to connect slicers to one main slicer. I have different source data. All slicers have common denominator, such as country. The idea would be to click on the Australia, hence all slicers that have Australia would be clicked.

    I would be very grateful if you could help me out by sharing VBA code.

    Best,

    Na2000

  2. #2
    Valued Forum Contributor
    Join Date
    09-25-2015
    Location
    Nowy Tomysl, Poland
    MS-Off Ver
    2019, O365
    Posts
    398

    Re: How to connect slicers from different source of data, VBA code

    I propose to combine different files into a single data source using Power Query

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

    Re: How to connect slicers from different source of data, VBA code

    this should work
    http://www.kubiszyn.co.uk/one-slicer...ot-tables.html

    though i agree power query would be better
    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] How do i change SourceData for all pivots in workbook while disconnect/connect slicers?
    By andygxxxv in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 07-04-2016, 10:15 AM
  2. Synchronising slicers with different source data
    By burger160 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-20-2016, 07:26 PM
  3. [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
  4. [SOLVED] Can Anyone Connect My Slicers In This Table
    By NewJerichoMan in forum Excel General
    Replies: 7
    Last Post: 04-26-2015, 11:10 PM
  5. Replies: 0
    Last Post: 11-12-2014, 08:39 AM
  6. Connect to Google Docs Spreadsheet as a data source?
    By Alabaster in forum Excel General
    Replies: 0
    Last Post: 01-13-2011, 01:48 PM
  7. VBA to connect to Database using ODBC data source
    By qed59 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-27-2010, 06:01 PM

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