Every day I add a new row of data to a spreadsheet. At the foot of this
growing array of numbers are several rows of formulae which need to use the
latest data added to the column immediately above them in order to make a
computation. Currently I have to physically change these formulae every day
in order to accomplish this but I'm sure there must be a better way.