draging formula
 

hi there
i have A column on sheet1 with 50 rows (data)
i want to just trnsfer it on sheet2 like we usually do =sheet1!a1 but i want
it dgaging accross the column a,b,c,d etc
is there a way of doing this without having to move from one sheet to
another ===
many thanks
jez