Forum Discussion
Maxamus070
Oct 20, 2020Copper Contributor
Create a Records Section
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 s...
Maxamus070
Oct 20, 2020Copper Contributor
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.
Bennadeau
Oct 21, 2020Iron Contributor
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.