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

[Shannon]

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.

 

[Trevor Shuttleworth]

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

 

[Gord Dibben]

Shannon

Try edit>replace

what: january

with: february


Gord Dibben MS Excel MVP