I am trying to come up with a worksheet that keeps track of stats for a team
in the NHL for a regular season. I would like to enter the information once
then have it copyied to a data table, i.e. game 26 data copied to the correct
row for game 26. I have one input table on my worksheet and the rest of the
sheet is locked. I would like to enter the data for the game, i.e. scoring
by periods and shots on goal, and then have excel copy it to the correct
position on my data table for the regular season. I keep getting stuck in
circular reference loops and am having a pretty hard time getting around it.
Any help would be appreciated.