Forum Discussion
Filter from one sheet to multiple others
You can apply a Pivot Table like in the screenshot. If you then double-click on cell E2 a new sheet is created which shows a table of all employees in the Engineering department. This can be done correspondingly for the other departments if you double-click in cells E3, E4 and E5.
You can apply a Pivot Table like in the screenshot. If you then double-click on cell E2 a new sheet is created which shows a table of all employees in the Engineering department. This can be done correspondingly for the other departments if you double-click in cells E3, E4 and E5.
Any chance you could show a screenshot of the side of the screen with the Pivot Table Fields set up? I am having trouble making it look the same and I am wondering how you arranged it?
Of course. In the screenshot you can see the set up and "Anzahl" is the "Count" in english.
- That is amazing!! Thank you so much for the help!
