bweisman12
New Member
- Joined
- Jul 30, 2019
- Messages
- 11
Hi,
I have 4 slicers which I am using to be able to update multiple pivot tables at once.
My question is, is there a function/formula to where I can have the sliders automatically update based on the contents of another cell?
Example:
I have a sheet containing a list of every restaurant in America and it's corresponding geographical region. If I were to paste "Billy's Pancakes" into a cell, could the geographical region slicer run a search (or vlookup) against Billy's pancakes in the data sheet and automatically update?
Thanks!
I have 4 slicers which I am using to be able to update multiple pivot tables at once.
My question is, is there a function/formula to where I can have the sliders automatically update based on the contents of another cell?
Example:
I have a sheet containing a list of every restaurant in America and it's corresponding geographical region. If I were to paste "Billy's Pancakes" into a cell, could the geographical region slicer run a search (or vlookup) against Billy's pancakes in the data sheet and automatically update?
Thanks!
Last edited: