copying formulas forward and have the column refference move backw

D

D

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.
 
E

Elkar

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
 
H

Harlan Grove

D said:
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
Click to expand...
....

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.
 
Top