Inserting a row...I want the formula to change...

[lilcrum3]

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?

 

[RalphA]

Since we have no way of knowing what your formula or data looks like, I will post here the germ for one possible solution.

Suppose you have a 9 in cell A9, and, in cell A10, you have the formula, =A9. If you insert a new, empty row 10, and insert, say, a 10 in cell A10, your formula, now in A11, still shows =A9, which is a 9. But, we want to show what is in cell A10, which is a 10, in cell A11. Here is one way:

Before inserting the new row 10, change the formula in cell A10 from =A9, to =INDIRECT("A"&ROW()-1). Now, insert the new row 10, and enter the value 10 in cell A10. You will now get cell A11 to show the contents of cell A10, which is a 10.

Do let us know if this idea has allowed you to solve your problem.

 

[lilcrum3]

That worked perfect. Thanks!