How may one move a value to ArbitraryCell, say D17, given ColumnName, say M, and RowNumber, say 83, being the location of the cell with the desired data/formula/value?
In a spreadsheet that updates itself, suppose the following:
the Range of interest is in column M,;
within that Range the Value of interest is in row 83; and
cell D17 has the equivalent of “=+M83.”
Suppose also, that as a CertainVariable in the spreadsheet changes, the row number of the Value of interest will change. If this CertainVariable increases (or decreases) by i, the row number will increase (or decrease) by i for all values within the Range e.g. if i = 3, the new RowNumber would be 86. We would want the value in D17 to become the equivalent of “=+M86.”
How does one change the value in D17 from the equivalent of “=+M83” to the equivalent of “=+M86?.”