Help Please

%3CLINGO-SUB%20id%3D%22lingo-sub-3022249%22%20slang%3D%22en-US%22%3EHelp%20Please%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3022249%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20for%20taking%20the%20time%20to%20read%20this.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20run%20a%20baseball%20league%20and%20use%20basic%20excel%20stuff%20to%20track%20stats%2C%20rosters%2C%20etc.%20%26nbsp%3BI%E2%80%99m%20trying%20something%20to%20make%20life%20easier.%20Can%20I%20use%20a%20master%20sheet%20with%20data%20and%20link%20that%20data%20to%20go%20into%20multiple%20sheets%20just%20by%3F%20Each%20team%20in%20the%20league%20has%20a%20tab%20for%20its%20players%20and%20salary.%20I%20wanted%20to%20use%20a%20master%20sheet%20with%20all%20the%20players%20and%20the%20players%20salary%20and%20link%20that%20to%20all%20the%2024%20team%20tabs.%20So%20if%20a%20trade%20occurs%20I%20could%20go%20to%20the%20master%20sheet%20with%20all%20the%20players%20just%20switch%20the%20teams%20in%20that%20sheet%20and%20it%20will%20then%20automatically%20swap%20those%20players%20in%20the%20individual%20team%20tabs.%20Is%20this%20possible%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3022249%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3024014%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20Please%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3024014%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1234773%22%20target%3D%22_blank%22%3E%40Coly88%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3EThe%20good%20news%20...%20everything%20is%20possible%20with%20Excel%20%3A).%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3ESo%20I%20can%20answer%20all%20of%20your%20questions%20with%20a%20%22yes%22.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3EThe%20less%20good%20...%20everything%20takes%20time%20and%20knowledge.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3EI%20can%20(as%20far%20as%20my%20modest%20knowledge%20allows)%20and%20I'm%20sure%20all%20the%20other%20helpers%20will%20be%20happy%20too%20help%20you%20with%20some%20of%20the%20steps%2C%20but%20unfortunately%20I%20don't%20have%20the%20time%20to%20set%20up%20the%20whole%20thing.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3ESo%20if%20you%20get%20stuck%20in%20any%20step%2C%20I%20could%20try%20to%20help%20you%20(as%20far%20as%20I%20can).%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3EThank%20you%20for%20your%20understanding%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3EFurthermore%2C%20I%20wish%20you%20much%20success%20with%20your%20project.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Thank you for taking the time to read this.

 

 

I need help.

 

I run a baseball league and use basic excel stuff to track stats, rosters, etc.  I’m trying something to make life easier. Can I use a master sheet with data and link that data to go into multiple sheets just by? Each team in the league has a tab for its players and salary. I wanted to use a master sheet with all the players and the players salary and link that to all the 24 team tabs. So if a trade occurs I could go to the master sheet with all the players just switch the teams in that sheet and it will then automatically swap those players in the individual team tabs. Is this possible?

1 Reply

@Coly88 

The good news ... everything is possible with Excel :).

So I can answer all of your questions with a "yes".

The less good ... everything takes time and knowledge.

I can (as far as my modest knowledge allows) and I'm sure all the other helpers will be happy too help you with some of the steps, but unfortunately I don't have the time to set up the whole thing.

So if you get stuck in any step, I could try to help you (as far as I can).

 

Thank you for your understanding

 

Furthermore, I wish you much success with your project.