Thu, 23 Aug 2007 16:24:00 -0700 from Tim Elhatton
:
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...?

If Data is the name of other worksheet, then you forgot a bang mark
(!).

=indirect("'Data'!$G" & 22*col()-11)


--
"First prove what you're saying, then whine about it."
-- /The People's Court/
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/