Forum Discussion
Solved
Is there a way to output specific rows based on dropdown option?
I am creating a Training record spreadsheet for my organisation, and I am trying to find out if there is a way to use a dropdown list to specify which row I want to pull data from my main table.... ...
- See: https://jkp-ads.com/articles/slicers.asp (the article is about pivot table slicers, but table slicers behave the same)
Hi Jan,
Is a slicer different to the filter function of normal tables?
Is a slicer different to the filter function of normal tables?
See: https://jkp-ads.com/articles/slicers.asp (the article is about pivot table slicers, but table slicers behave the same)
- Hi Jan,
After a bit of googling this morning, this has been a great solution to my problem!
Thank you for the suggestion!, I've managed to create a slicer that filters by staff name and I have locked it to the cell that should have the dropdown, so it doesn't look too amiss! 😄OliverBoardman Thanks. It is helpful for others if you mark my reply as the answer to your question.
