I'm keeping track of points scored for players in a fantasy basketball league. I have all of the players divided into their fantasy teams (so that players from different schools are on the same teams). However, I'd like to have a section at the bottom of the spreadsheet with players grouped into the schools that they actually play for so that I can just look at the box scores and input the points by team that way, instead of having to go through all the fantasy teams and find each player one by one from the team of the of the box score and entering their points individually (very time consuming). I'd like the values that I enter for the players grouped by school at the bottom to be inputed to their corresponding row where each player is for their fantasy team. This would save me so much time. Does anybody understand what I'm trying to do or know how I could go about doing this? Any suggestions or advice would be greatly appreciated.
Bookmarks