one way:

=INDEX('Raw Data'!$E:$E,(ROW()-1)*7+1)

In article ,
"Patti" wrote:

I've tried several different ways to do this with no luck. I have a formula
in a cell that refers to a cell on another worksheet in the same book. I need
to have each subsequent formula (horizontally) refer to the cell referenced,
but offset by 7 rows.

Here's the example:
Cell A1 formula Cell A2 should refer to Cell A3
should refer to
='Raw Data'!$E1 ='Raw Data'!$E8 ='Raw Data'!$E15

Help please?