Could you have another look at my 2nd post....I am having a tough time
getting this done. Thanks

"Stan Brown" wrote:

Thu, 23 Aug 2007 20:41:45 -0400 from Stan Brown
:
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)

Gary's and I posted nearly the same thing, except that I should have
said column() and not col().

--
"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/