I have a file that I will be inserting rows at the end of each moth..
I have a row that has a formula in it to figure out a score (row 10)....the data used to figure out the score is in row 9. Row 9 is July stats. I want to insert a row after row 9 for August stats, and i want the score that is row 11 (was in row 10) to reference the new August data (row 10). Everytime I insert a row, the formula stays constant with July stats (row 9). Is there a way I can get the formula to not stay constant?
I have a row that has a formula in it to figure out a score (row 10)....the data used to figure out the score is in row 9. Row 9 is July stats. I want to insert a row after row 9 for August stats, and i want the score that is row 11 (was in row 10) to reference the new August data (row 10). Everytime I insert a row, the formula stays constant with July stats (row 9). Is there a way I can get the formula to not stay constant?