Remote Updating Row Number in Formulas

Excel 97

I am looking for a way to update a row number (724 in my example), in a series of formulas like the one shown.

The column numbers vary from formula to formula, but the row numbers need to be the same, and to be periodically updated.

It's a lot of work to manually update all of the formulas.

I would like to be able to do it, on demand, from a remote cell, where I have entered a new row number

Example Formula:

=((B13-B$724)*364.25)/(B$724*($A13-$A$724))

Would a "NAME" work?

For example, could I name my remote cell, containing the updated row number, "ROW" and then use B$ "ROW" & $A$ "ROW" in the formulas?

I probably don't have the formatting right.

I've given it a shot, but it won't worked for me.

Am I why off, or is it just a formatting issue?

 

Instead of using $A$724 in your formula, put a cell reference to some empty cell. Then you can make that cell any value you like. Eg., replace $A$724 in your formula with $A$1 (if A1 is empty) and then in cell A1 you could place the formula; @sum(A724) , or whatever else pleases you. That would allow you to change all instances of the formula from a single place. That assumes you edit all instances of the original formula accordingly when making this change.