hi all, is it possible to use slicer values selected by the user as variables in another query? my slicer filters dates such that there is starting date (Date1) and an ending date (Date2). it reads from a DatesTbl. I have another table which lists Activities including Activity Start and Activity End dates. This table and the date slicer are on my dashboard. I want the date slicer to filter the Activity table to show only those Activities that are Active during the dates selected (on the date slicer).
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
passing variables (like in VBA)
- Thread starter ajm
- Start date
