title: Use Slicers's Selection in Formula or in VBA
body: <p>I have a pretty complex Data Model (built into PowerPivot), where I have some slicers in a Dashboard.
  All nice and dandy, however, I want those slicers to be applied to another Table which is Not (and can not be) part of the DataModel.</p>
  
  <p>Therefore, I am using an Excel UDF to capture the slicers’ selections.
  The part that I’m struggling with begins here. I need to use the selections that I capture from the slicers and use VBA to filter the UnLinked Table, OR use a SUMPRODUCT/SUMIFS formula to calculate the results I want from the UnLinkedTable.
  For example, if in the “PRODUCTS” Slicer I select “A”, “B”, “C” and “D”, my UDF formula returns: “A, B, C, D”. 
  If everything is selected in the slicer, the formula returns “All Items”.</p>
  
  <p>Now, how do I filter in VBA the UnLinkedTable[PRODUCT] column using that “A, B, C, D” result, or how do I write a SUMPRODUCT or SUMIFS formula in Excel? Keep in mind that I have multiple slicers and multiple columns in the UnLinked table.
  I highly appreciate your help!</p>