Put this in column A and copy across:

=INDIRECT("Data!G" & 11+22*(COLUMN()-1))

--
Gary''s Student - gsnu200739


"Tim Elhatton" wrote:

Here is my question:

1 2 3 4

$1.15 $1.17 $1.59 $1.43

'Data'!$G11 'Data'$G33 'Data'$G55 ????

I want to be able to automatically drag my formula across....each time
adding 22 to the cell reference.....so the next cell formula above would be
'Data'$G77...?
Right now I am doing this manually....any ideas?
Thanks