gheyman
Well-known Member
- Joined
- Nov 14, 2005
- Messages
- 2,341
- Office Version
- 365
- Platform
- Windows
Is there a way to take the selections made in a Slicer and Store them as values in a cell(s)?
What I am trying to do is have a tab that has several Slicers (based on a table in my workbook)
When the user makes selections from the several slicers, those selections are stored in cells. I want to take those selection and add them to a table. Then use the data from those tables in Power Query to filter data on other tables.
Why? Because I am trying to make it so that all the tables are filtered to the same data. The user only has to make those filter selections once - and not have to go to each table on each tab and individually filter them.
Hope that makes sense.
Thanks
Greg
What I am trying to do is have a tab that has several Slicers (based on a table in my workbook)
When the user makes selections from the several slicers, those selections are stored in cells. I want to take those selection and add them to a table. Then use the data from those tables in Power Query to filter data on other tables.
Why? Because I am trying to make it so that all the tables are filtered to the same data. The user only has to make those filter selections once - and not have to go to each table on each tab and individually filter them.
Hope that makes sense.
Thanks
Greg