diamondjoechubbs
New Member
- Joined
- Oct 26, 2020
- Messages
- 18
- Office Version
- 365
- Platform
- Windows
I have an excel file that contains agent metric data. I am trying to create a sheet that will contain a single row of data from all of my other sheets that contains a drop down so that I can select an agent and it pulls just their information over so that it can be used to show that agent only their data and protects confidentiality for all other agents. Bonus points if I can use the same method to pull all agents for a given team. Thank you in advance for pointing me in the right direction.