For a few years I've maintained my own database for college basketball. There's nothing too complicated about it, but it's very time intensive and I'm thinking there has to be a way to make it easier, but I'm not an Excel expert.
In short, here's what I'm trying to solve. I have a sheet for each team. So, as an example, after Syracuse plays St. John's, I have to go onto the Syracuse sheet and input the score of the game and the spread, then go onto my St. John's sheet and do the same thing. So I'm inputting the same score twice, just so I can quickly have the result regardless of whether I'm on the Syracuse sheet or the St. John's sheet.
Anyone out there who really knows their way around Excel want to take five minutes to look at this and provide suggestions? Thanks.
In short, here's what I'm trying to solve. I have a sheet for each team. So, as an example, after Syracuse plays St. John's, I have to go onto the Syracuse sheet and input the score of the game and the spread, then go onto my St. John's sheet and do the same thing. So I'm inputting the same score twice, just so I can quickly have the result regardless of whether I'm on the Syracuse sheet or the St. John's sheet.
Anyone out there who really knows their way around Excel want to take five minutes to look at this and provide suggestions? Thanks.