I have a spreadsheet with a master list of data, and a secondary spreadsheet
with a calculations based on that data. The calculations are organised into
columns representing the months, and the formulas contain the range that
represents that month. I've been copying and pasting the column of formulas
to the next month, and manually changing the cell references within each
formula. (they refer back to my first spreadsheet). I am looking for a way to
automate this tedious task. Any help would be much appreciated.