Pull data from other sheets

[diamondjoechubbs]

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.

 

[mrshl9898]

Sounds like you'd need to make exports after you select the agent or team. Then send that file instead.

If you need some code to accomplish this then data is required. Ranges, Headers, Sheet names.

 

[diamondjoechubbs]

Sounds like you'd need to make exports after you select the agent or team. Then send that file instead.

If you need some code to accomplish this then data is required. Ranges, Headers, Sheet names.

I am looking for a tool name or function, to first enable me to select a criteria drop down on sheet a, that pulls that name from column a, sheet b and then in the subsequent sheets I can xlookup to pull the data

 

[mrshl9898]

Ok, use a table then a Pivot of that with a slicer perhaps

 

[diamondjoechubbs]

Ok, use a table then a Pivot of that with a slicer perhaps

Would you happen to be able to provide me with a guide or link to what you mean?

 

[mrshl9898]

go to your table, click somewhere in it and press ctrl+t, select ok

then insert>pivot table, select somewhere to insert it

then insert>slicer.


Maybe just google Pivot table tutorial