bs0d
Well-known Member
- Joined
- Dec 29, 2006
- Messages
- 622
I have multiple slicers on multiple tables. Most of the data is pulled from a database, but some of it includes calculations made in the Excel sheets. It's my understanding, that because they're from multiple source tables, I cannot make all the tables respond to a single slicer selection. At least, using pre-defined methods.
However, I was thinking surely there's a simple VBA solution. Assume I create one "master" slicer. Is there a way I can make all of the tables with slicers on other tabs filter to the selection made in the master using some VBA? All of my tables on other tabs share a common field and values that my master slicer would point to.
Thanks,
However, I was thinking surely there's a simple VBA solution. Assume I create one "master" slicer. Is there a way I can make all of the tables with slicers on other tabs filter to the selection made in the master using some VBA? All of my tables on other tabs share a common field and values that my master slicer would point to.
Thanks,