Excel Pivot table between two tabs

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3139061%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3EExcel%20Pivot%20table%20between%20two%20tabs%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3139061%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CP%3EI%20have%20one%20tab%20in%20a%20spreadsheet%20for%20team%20members'%20start%20dates%2C%20then%20another%20with%20the%20opportunities%20we%20have%20won%20at%20that%20client.%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EAm%20looking%20to%20be%20able%20to%20set%20up%20a%20pivot%20table%20to%20tell%20me%20all%20of%20the%20opportunities%20each%20team%20member%20should%20be%20tagged%20on%20based%20upon%20their%20start%20date!%26nbsp%3B%20HELP!!!%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EHave%20been%20looking%20for%20days%20and%20boss%20is%20getting%20upset!%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20any%20pointers%20links%20etc...%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3139061%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CLINGO-LABEL%3EExcel%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E
New Contributor

I have one tab in a spreadsheet for team members' start dates, then another with the opportunities we have won at that client.

 

Am looking to be able to set up a pivot table to tell me all of the opportunities each team member should be tagged on based upon their start date!  HELP!!!

 

Have been looking for days and boss is getting upset!

 

Thank you for any pointers links etc...

 

0 Replies