adjust the range in a long column of formulas to accomodate new da
 

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.

adjust the range in a long column of formulas to accomodate new da
 

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.

adjust the range in a long column of formulas to accomodate new da
 

Shannon

Try editreplace

what: january

with: february


Gord Dibben MS Excel MVP

On Fri, 11 Aug 2006 10:13:02 -0700, Shannon
wrote:

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.