check indirect()
=indirect("R1C"&row()-cf,0)
(Cf is the correction factor to get the row()-1 to equal 1 (or whatever
column you want to start ) based on the row you start the equations.

"Rich" wrote:

when using an absolute refrence say a$1 , is it possible to have the a
change to b c d e ect when pasting the formula down the col rather than
accross the row,

im aware that by pasting accross the A would auto move but with the current
set up it dosnt move when pasting down the col