copying formulas forward and have the column refference move backw
 

I need a formula that I can copy forward and will move the coulum refrence
backwards ie, the data I have is in colums G,F,E,D,C,B,A and I need it
referenced in another sheet A,B,C,D,E,F,G. So A=G,B=F, C=E and so on

It is a simple cell reference but it is for a very large amount of data, so
I need a formula that will be able to update the colulm refrences going
backwards when it is copied across the row.

copying formulas forward and have the column refference move backw
 

Try this in cell A1 of Sheet2:

=OFFSET(Sheet1!$A$1,0,-COLUMN()+10)

Copy across to cell J1.

Where, 10 is the total number of columns (A thru J). Adjust this to meet
your actual needs.

HTH,
Elkar


"D" wrote:

I need a formula that I can copy forward and will move the coulum refrence
backwards ie, the data I have is in colums G,F,E,D,C,B,A and I need it
referenced in another sheet A,B,C,D,E,F,G. So A=G,B=F, C=E and so on

It is a simple cell reference but it is for a very large amount of data, so
I need a formula that will be able to update the colulm refrences going
backwards when it is copied across the row.

copying formulas forward and have the column refference move backw
 

D wrote...
I need a formula that I can copy forward and will move the coulum
refrence backwards ie, the data I have is in colums G,F,E,D,C,B,A
and I need it referenced in another sheet A,B,C,D,E,F,G. So A=G,B=F,
C=E and so on
....

If the original data were in A3:G3 and you want it reversed in A5:G5,

A5:
=INDEX($A3:$G3,COLUMNS(A5:$G5))

Fill A5 right into B5:G5.