Quickest or Best way to change Column reference

[Bravo2003]

=SUMIF('2014 Sales'!$CR$1:INDEX('2014Sales'!$CR:$CR,A15_2014_Sales),$AR594&"*",'2014Sales'!$F$1:INDEX('2014 Sales'!$F:$F,A15_2014_Sales))

In the above formula the Reference to Column F is a changeablereference.

i.e – F = January / L = Feb / R = Mar, etc…

I need to copy this formula in to new columns – what’sthe best way to update the F to L, and so on, in all the formulas?

Any one understand what I mean and can help?

 

[steve the fish]

How do you want to reference it? Based on headers? Are the formulas being dragged across? Down? Answer is it depends.

 

[Bravo2003]

How do you want to reference it? Based on headers? Are the formulas being dragged across? Down? Answer is it depends.

Not sure it will work from headers as they are differentformats
i.e. master data shows as January 2014 / but the resultsheader is Jan-14 (cell data = 01/01/2014)
Due to layout and formatting it may not be changeable tomatch both?
But this would be the better idea I think if I could useheaders?
Other issue though is there are 6 headers for January2014 and each month, with different data in each column
There are sub headers that could work in conjunction withthe headers if workable?

The formula are copied across for each column but notadjacent, so result from F:F sits in column BO, L:L sits in BW, etc…

Again if any of that makes sense – any help?

 

[RoryA]

How many do you have to do?

 

[Bravo2003]

8 years x 12 months x 4 different choices

I know may be just as quick to use Replace!