Quote:
Originally Posted by calumniate
Is your data safe enough to just give a power pivot workbook with slicers?
|
This is the approach I was going down originally, however, the data-set itself is supposed to change based off of the user selection from the drop-down.
So basically, there is a vlookup that is occuring, that based off of the drop-down menu selection a vlookup formula changes the dataset range that the pivot table reads.
I think a data slicer would only work for a static data range, so I think that's complicating things (including the original attempts at this macro).