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.