As you've not had any replies, it could be that you need to provide more
information. Maybe some examples of what the master data looks like and
what the formulae are that you need to copy and modify in the secondary
spreadsheet.

What are your column headings in each of the sheets ?

Could be that you could use COUNTIF, SUMIF, SUMPRODUCT or OFFSET but as I
don't know what it is you're doing it's difficult to guess at the answer

Regards

Trevor


"Shannon" wrote in message
...
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.