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.