Create a Records Section

%3CLINGO-SUB%20id%3D%22lingo-sub-1800644%22%20slang%3D%22en-US%22%3ECreate%20a%20Records%20Section%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1800644%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%20I%20have%20a%20simple%20workbook%20for%20a%20sports%20pick%20league.%20its%20has%2017%20different%20sheets%2C%20each%20one%20is%20a%20schedule%20of%20each%20time%20playing%20as%20well%20as%20which%20team%20won%20or%20lost.%20I%20am%20trying%20to%20create%20a%20records%20sheet%20where%20it%20will%20automatically%20calculate%20the%20wins%20and%20losses%20for%20each%20of%20the%20teams%20within%20the%20workbook.%20Any%20ideas%3F%20Thanks%2C%20Max%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1800644%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1801058%22%20slang%3D%22en-US%22%3ERe%3A%20Create%20a%20Records%20Section%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1801058%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F839594%22%20target%3D%22_blank%22%3E%40Maxamus070%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20you%20calculate%20the%20win%2Flost%20for%20each%20team%20in%20their%20respective%20sheet%20and%20the%20reference%20the%20cells%20that%20contains%20those%20numbers%20in%20your%20report%20sheet%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%3DSheet2!A4%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3EIn%20the%20above%20example%2C%20Sheet2%20is%20on%20of%20your%20teams%20sheet%20just%20use%20whatever%20sheet%20name%20you%20currently%20have.%20And%20A4%20is%20the%20cell%20where%20your%20Wins%20would%20be%20located.%20You%20can%20change%20that%20to%20whatever%20the%20cell%20will%20be.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1801115%22%20slang%3D%22en-US%22%3ERe%3A%20Create%20a%20Records%20Section%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1801115%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F703724%22%20target%3D%22_blank%22%3E%40Bennadeau%3C%2FA%3E%26nbsp%3BSo%20are%20you%20suggesting%20keeping%20track%20of%20the%20records%20manually%20as%20each%20week%2Fsheet%20passes%20and%20mirroring%20whichever%20cell%20on%20the%20records%20sheet%3F%20That%20would%20work%2C%20but%20not%20really%20what%20I'm%20looking%20for%2C%20if%20that%20is%20what%20you're%20saying.%20I%20would%20like%20to%20create%20a%20search%20through%20the%20workbook%2C%20each%20sheet%2C%26nbsp%3Bfor%26nbsp%3Bindividual%20teams%20and%20tally%20weather%20they%20have%20a%20%22win%22%20in%20the%20next%20cell%20or%20a%20%22lost%22%2C%20or%20some%20other%20defining%20characteristic.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello, I have a simple workbook for a sports pick league. its has 17 different sheets, each one is a schedule of each time playing as well as which team won or lost. I am trying to create a records sheet where it will automatically calculate the wins and losses for each of the teams within the workbook. Any ideas? Thanks, Max

3 Replies

Hi @Maxamus070,

 

Can you calculate the win/lost for each team in their respective sheet and the reference the cells that contains those numbers in your report sheet?

 

=Sheet2!A4

In the above example, Sheet2 is on of your teams sheet just use whatever sheet name you currently have. And A4 is the cell where your Wins would be located. You can change that to whatever the cell will be.

@Bennadeau So are you suggesting keeping track of the records manually as each week/sheet passes and mirroring whichever cell on the records sheet? That would work, but not really what I'm looking for, if that is what you're saying. I would like to create a search through the workbook, each sheet, for individual teams and tally weather they have a "win" in the next cell or a "lost", or some other defining characteristic.

@Maxamus070 

Can you share your workbook here? I definitely understand that you want to automate things but need to see what you're working with to see where automation will be possible.